Use Conditional formatting, see details in Help!
Regards,
Stefi


€žDri€� ezt Ã*rta:

Hi All
I'm working on a spreadsheet for a maintenance program. I'm looking for a
way to change the cell colour depending on when a task is due. For example:
when a monthly task is due I would like the cell colour to change to remind
me that it is due in a week.
Thanks