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

Perhaps a quick play to ease you in as well ?

Assuming the due dates are in col B, in B2:B10 (say), and we want the entire
row(s) to appear shaded yellow if the due date is <= 7 days from today

Select row2 down to row10 (select the row headers)
[this ensures that A2 is active]

Click Format Conditional Formatting
Under Condition 1, make the settings:
Formula is: =AND($B2<"",$B2-TODAY()<=7)
Click Format button Patterns tab Yellow OK
Click OK at the main dialog

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Dri" wrote in message
...
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