Change row color based on condition of celss

B

B G

I would like to make the row color turn red based on the follow condition:

If the value in column P (all rows) is less than the value in column Y then
I want to change the color of the row to Red.

I know this is in condiitional formating but I cannot get it to work. I am
a very basic excel user so am not familiar with all the ins and outs. Any
help would be appreciated.
 
B

B G

I tried this and didn't get the cells to change colors. This is what I have
the conditional formatting condition set as:

Condition 1
Formula is ="IF$P3>$Y3"
the format selection shows all letters background Red.

What did I do wrong?
 
P

Peo Sjoblom

=$P3>$Y3

try that instead


--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey
 
Top