Conditional Formatting

A

AJK

Is there a way to look at the value of one cell (A1 for example) and change
the formatting of another cell (B1 for example). I want to look at first cell
in a row and then change color (fill) of entire row depending on value in the
1st cell in the row.
 
R

robert111

in cell B1 apply conditional formatting

formula
if $A1 >3

and set format to fill red

copy this conditional formatting with format painter as required


note you can have up to 3 conditions if you need more than 1 colour
 
A

AJK

I had tried that and can't seem to make it work. The formula was ="if$I4=Y",
I also tried it with a numeric value like you suggested. Could you send me a
small sample worksheet showing how it works?

Thanks for your help.

Joe
 
Top