formatconditional formatformula isput in your formulaformat as desired.

--
Don Guillett
SalesAid Software

"Addisonbc" wrote in message
...
I would like to know if there is a way to have a cell automatically change
colors; here is my scenario. I track dates of several training sessions
that
are a requirement for our personnel. Some need to be reaccomplished every
12
months, 15 months and 30 months. When someone's last accomplished date is
within 30 days of expiring, I'd like the "due date" cell to change colors.