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