Cell color date sensitive

[mcneilr]

Folks,

I am trying to build a tracking product for training events that are
accomplished and those that are due. I want to have a “cell†that turns from
Green – Yellow – Red, based on a timeframe that I pick. Example: John Doe
completes yearly Egress training on 1-18-2008 that cell will remain Green
until 3 months from his due date and then the cell will turn Yellow. At the
date that Egress training is due again the cell will turn Red until the
training is completed. I hope that I have not confused anyone… your help in
this will make my job easier to track upcoming and overdue training.

 

[CLR]

The feature you need is called Conditional Formatting. You can access it by
doing Format > ConditionalFormatting > and following the menus. You can
invoke a base color to the cell, and 3 conditional ones. Try it, and post
back if you have questions.

Vaya con Dios,
Chuck, CABGx3

 

[mcneilr]

I am sorry “CLR†I am not fluent in Code. Can you give me an example of how
to write the string using today’s date and have the cell Green. Maybe then I
can go in and modify it for the rest of my tracking.

 

[CLR]

Format > ConditionalFormatting > FormulaIs: > =$A1=TODAY() > FormatButton >
PatternsTab > Pick a color > OK > OK

Vaya con Dios,
Chuck, CABGx3

 

[mcneilr]

CONDITION 1 =E4:E991=TODAY()
CONDITION 2 OK that worked, now for me to project out 9 months and have that
date turn Yellow??????????????
CONDITION 3, Now if the training expires 12 months from todays date
Thank You...
RGM

 

[CLR]

I think maybe using =TODAY() will mess you up in the long run............
This should work better...........

Use CellValueIs: > equal to > =$A$1 for the base date you wish to
reference
CellValueIs: > equal to > =$A$1+270 for 9 months later
CellValueIs: > equal to > =$A$1+365 for one year later

Presuming A1 is where a date is that you wish to reference........you can of
course put it in any other cell.........just change A1 to that cell number.

Vaya con Dios,
Chuck, CABGx3

 

[mcneilr]

Thanks so much... Condition 1 works great, is there a way to perform a test
to check out Condition 2 & 3

 

[CLR]

Put a string of about 20 dates or so down column B and do your formatting on
that column, except only use +1day and -1day, they whatever date you type in
A1, should light u 3 consecutive cells

Vaya con Dios,
Chuck, CABGx3