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" wrote:

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

Vaya con Dios,
Chuck, CABGx3

"mcneilr" wrote:

I am sorry €œCLR€� I am not fluent in Code. Can you give me an example of how
to write the string using todays date and have the cell Green. Maybe then I
can go in and modify it for the rest of my tracking.
--
RGM


"CLR" wrote:

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" wrote:

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.

--
RGM