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