Conditional Formatting Problum

Closed
Rana - Dec 27, 2015 at 12:54 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Dec 27, 2015 at 08:08 AM
Hello,

i have excel 2010

i have two rows. a & b
i want if row a cell value not equal b cell value then change color cell b.
(Note this format apply only one cell i want to copy & past down side then pick value of cell A1 not change A2 or A3.
Please Solve this Problem.

Thanks

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Dec 27, 2015 at 08:08 AM
So from what I am getting is that lets say you have 3 rows populated
R1, R2, and R3

you can to compare a cell in R2 vs a cell in R1 and if not equal apply format to whole row R2

then you want to compare a cell in R3 vs cell in R1 and if not equal apply format to whole row R3
0