have a look at formatconditional formatput in an appropriate formula

--
Don Guillett
SalesAid Software

"Andrew" wrote in message
...
I am dealing with a date of lets say 5/5/05 in Cell B6, and six months
later
I want to be informed in Cell B7 of the Due Date (11/5/05) and Color
change
of that cell (B7) to red. How do I do this???