CONDITIONAL FORMATING FORMULA

[Kanmi]

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

 

[RagDyeR]

Try this:

=D2<=TODAY()+60
--

HTH,

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


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

 

[DILipandey]

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.)
(e-mail address removed)
(e-mail address removed)
New Delhi, India

 

[RagDyeR]

Try this instead:

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

HTH,

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


Try this:

=D2<=TODAY()+60
--

HTH,

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


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

 

[Kanmi]

Thanks alot but can i have formular for rows instead of cell

 

[RagDyeR]

Select the row and use this:

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

HTH,

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


Thanks alot but can i have formular for rows instead of cell