Cell color changes when date gets closer
 

Hi:

I have a large spreadsheet that I track employee training on. The cells
contain the DUE date of next training I would like to format it so that if a
training date is past the DUE date the cell color is "red". If the date is
within 0-30 days the cell is "amber", and if it is within 31-60 days of DUE
date then "yellow".

Many thanks for you help....

Cell color changes when date gets closer
 

See http://www.xldynamic.com/source/xld.CF.html#due

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Ralph" wrote in message
...
Hi:

I have a large spreadsheet that I track employee training on. The cells
contain the DUE date of next training I would like to format it so that
if a
training date is past the DUE date the cell color is "red". If the date
is
within 0-30 days the cell is "amber", and if it is within 31-60 days of
DUE
date then "yellow".

Many thanks for you help....

Cell color changes when date gets closer
 

Use Conditional Formatting.

Say Column D contains the due dates, starting in D2.

Select D2, then from the Menu Bar:
<Format <Conditional Formatting,

Change "Cell Value Is" to "Formula Is", and enter this for Condition 1:

=D2<TODAY()

Then click on "Format", and choose a Red Pattern.

Click on <Add, then
Change "Cell Value Is" to "Formula Is", and enter this for Condition 2:

=D2<=TODAY()+30

Then click on "Format", and choose an Amber Pattern.

Click on <Add, then
Change "Cell Value Is" to "Formula Is", and enter this for Condition 3:

=D2<=TODAY()+60

Then click on "Format", and choose a Yellow Pattern.

Then <OK <OK out.

Copy D2 down as needed.

If you already have dates entered in Column D,
use the Format Painter to copy down.

--

HTH,

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



"Ralph" wrote in message
...
Hi:

I have a large spreadsheet that I track employee training on. The cells
contain the DUE date of next training I would like to format it so that if
a
training date is past the DUE date the cell color is "red". If the date is
within 0-30 days the cell is "amber", and if it is within 31-60 days of DUE
date then "yellow".

Many thanks for you help....