Change row color based on condition of celss

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

[Bob Phillips]

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

--
HTH

Bob Phillips

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

"B G" <[email protected]> wrote in message
news:[email protected]...
> 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

[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?
--
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" <[email protected]> wrote in message
> news:[email protected]...
> > 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
>
>
>

[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


"B G" <[email protected]> wrote in message
news:[email protected]...
>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" <[email protected]> wrote in message
>> news:[email protected]...
>> > 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
>>
>>
>>