Thanks alot. I refer it to another cell that has today date then use that to
control the conditional formating =$I$11 using Cell Value and is working as i
want. Anyway thanks alot

"RagDyeR" wrote:

Try this instead:

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

HTH,

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


"RagDyeR" wrote in message
...
Try this:

=D2<=TODAY()+60
--

HTH,

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


"Kanmi" wrote in message
...
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