Select the row and use this:

=AND($D2<"",$D2<=TODAY()+60)
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"Kanmi" wrote in message
...
Thanks alot but can i have formular for rows instead of cell

"DILipandey" wrote:

Hi Kanmi,

Use following formula in conditional formatting window:-
=IF($D$2-TODAY()<=60,"True","False")
& choose the format as "Green".
--
Click on Yes, if it is useful.

Thanks & Best Regards,
Dilip Kumar Pandey
MBA, BCA, B.Com(Hons.)


New Delhi, India


"Kanmi" wrote:

Heading in cell D1- POS Interview Date -- Cell D2 4/23/10 (I need this
cell
to turn green 60 days prior to date.) Using conditional formating.
Please
what is the formular. Appreciate your time. Thanks