CONDITIONAL FORMATING FORMULA
 

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

CONDITIONAL FORMATING FORMULA
 

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

CONDITIONAL FORMATING FORMULA
 

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

CONDITIONAL FORMATING FORMULA
 

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

CONDITIONAL FORMATING FORMULA
 

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

CONDITIONAL FORMATING FORMULA
 

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

CONDITIONAL FORMATING FORMULA
 

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