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.
--
Barb

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

--
HTH

Bob Phillips

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

"B G" wrote in message
...
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.
--
Barb

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?
--
Barb


"Bob Phillips" wrote:

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

--
HTH

Bob Phillips

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

"B G" wrote in message
...
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.
--
Barb

=$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


"B G" wrote in message
...
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?
--
Barb


"Bob Phillips" wrote:

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

--
HTH

Bob Phillips

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

"B G" wrote in message
...
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.
--
Barb