Conditional Format Based on Date

[Ron A.]

How can I change the fill color of a cell based on a date. I would like the
cell to be green if the date in a cell is equal to or greater than 90 days
from todays date. Yellow if less than or equal to 90 days and Red if less
than or equal to 30 day from the current date. This is to track when an
employee's annual training is due.

 

[RagDyer]

Conditional Formatting

Click in the cell, say A3, then, from the menu Bar:
<Format> <Conditional Formatting>,
Change "Cell Value Is" to "Formula Is", and enter this:

=AND(A3<>"",A3>=TODAY()+90)

Click on "Format", and choose a Pattern of Green,

Then click on "Add" for the second condition,
Change "Cell Value Is" to "Formula Is", and enter this:

=AND(A3<>"",A3<=TODAY()+30)

Click on "Format", and choose a Pattern of Red,

Then click on "Add" for the third condition,
Change "Cell Value Is" to "Formula Is", and enter this:

=AND(A3<>"",A3<TODAY()+90)

Click on "Format", and choose a Pattern of Yellow.

Then <OK> out, and you should be done.

 

[Ron A.]

Thank you both for your reply. Exactly what I needed.
--
Aloha,
Ron A.

Conditional Formatting

Click in the cell, say A3, then, from the menu Bar:
<Format> <Conditional Formatting>,
Change "Cell Value Is" to "Formula Is", and enter this:

=AND(A3<>"",A3>=TODAY()+90)

Click on "Format", and choose a Pattern of Green,

Then click on "Add" for the second condition,
Change "Cell Value Is" to "Formula Is", and enter this:

=AND(A3<>"",A3<=TODAY()+30)

Click on "Format", and choose a Pattern of Red,

Then click on "Add" for the third condition,
Change "Cell Value Is" to "Formula Is", and enter this:

=AND(A3<>"",A3<TODAY()+90)

Click on "Format", and choose a Pattern of Yellow.

Then <OK> out, and you should be done.

 

[RagDyer]

You're welcome and thank you for the feedback.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

Thank you both for your reply. Exactly what I needed.