Turning a row color to "yellow" if one date field is greater than another.

I would like to automatically turn a row color to yellow if the current date
is greater than a "needed by" date column. What is the best way to do this?

Hi

Select the rows necessary and then go to Format/Conditional Formatting. If
your 'needed by' date is in column D use 'Formula Is' and then in the box
type:
=$D1=today()

Hope this helps.
Andy.

"Ray Stevens" <nfr@nospam.com> wrote in message
news:umTvfnURGHA.4976@TK2MSFTNGP11.phx.gbl...
>I would like to automatically turn a row color to yellow if the current
>date is greater than a "needed by" date column. What is the best way to do
>this?
>

Sorry - that's if column D equals today.
Try this:
=today()>$D1
Don't forget to set a pattern fill too!

Andy.

<AndyB> wrote in message news:OHqXtxURGHA.336@TK2MSFTNGP12.phx.gbl...
> Hi
>
> Select the rows necessary and then go to Format/Conditional Formatting. If
> your 'needed by' date is in column D use 'Formula Is' and then in the box
> type:
> =$D1=today()
>
> Hope this helps.
> Andy.
>
> "Ray Stevens" <nfr@nospam.com> wrote in message
> news:umTvfnURGHA.4976@TK2MSFTNGP11.phx.gbl...
>>I would like to automatically turn a row color to yellow if the current
>>date is greater than a "needed by" date column. What is the best way to do
>>this?
>>
>
>