CONDITIONAL FORMATING FORMULA

  • Thread starter Thread starter Kanmi
  • Start date Start date
K

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
 
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
 
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
 
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
 
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
 
Back
Top