Forum Discussion
Claude080
Feb 06, 2022Copper Contributor
Excel Highlight a row according to a change in a specific cell
am using Excel 2016 and i want an advice on how to do this: i have an excel table and i want to highlight each row basing on a change in a cell in row and change a color for example if c2,c3,c7 cont...
Claude080
Feb 06, 2022Copper Contributor
thank you Donald_Genes but what to do in case all of these c2, c3, and other are many in a big excel sheet let say the values that are the same and are many how will i click on each of them to ad them in the formulas yet am not even sure how many are they
Donald_Genes_
Feb 06, 2022Brass Contributor
Simple highlight all the range of Column that contains C2to whatever c10000 and use same logical Analysis.. Haven't seen the data to know what you really saying