Change cell colour by date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Use Conditional formatting, see details in Help!
Regards,
Stefi


„Dri†ezt írta:
 
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
 
Select row2 down to row10 (select the row headers)

Just a clarification that we could actually select rows beyond row10, i.e.
pre-format ahead of dates input in col B, since the CF formula includes
checks for blank cells in col B as well (via the part: $B2<>"").

---
 
Max,
Thanks for taking the time out to help me. You've pointed me in the right
direction perfectly.
Best wishes
 
Back
Top