Conditional Format Based on Date
 

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.

--
Aloha,
Ron A.

Conditional Format Based on Date
 

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.
--
HTH,

RD

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

"Ron A." wrote in message
news:B71D8B5A-9858-4B1E-B6C1-2D20458
...
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.

--
Aloha,
Ron A.

Conditional Format Based on Date
 

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


"RagDyer" wrote:

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.
--
HTH,

RD

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

"Ron A." wrote in message
news:B71D8B5A-9858-4B1E-B6C1-2D20458
...
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.

--
Aloha,
Ron A.

Conditional Format Based on Date
 

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

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Ron A." wrote in message
...
Thank you both for your reply. Exactly what I needed.
--
Aloha,
Ron A.


"RagDyer" wrote:

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.
--
HTH,

RD

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

"Ron A." wrote in message
news:B71D8B5A-9858-4B1E-B6C1-2D20458
...
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.

--
Aloha,
Ron A.