View Single Post
  #2   Report Post  
Old February 8th 06, 08:10 AM posted to microsoft.public.excel.newusers
Posts: n/a
Default Change cell colour by date

Use Conditional formatting, see details in Help!

„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.