Change row color based on condition of celss

[Guest]

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.

 

[Bob Phillips]

See http://www.contextures.com/xlCondFormat01.html

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Guest]

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?

 

[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