Thread: Excel 2007 Adding due date alerts

We all use Excel for keeping track of personal finance-paying bills, for
instance-wouldn't it be great if Excel could alert you of an approaching due date? Here's how you do it:

1.Select the cell that contains the due date and go to the Home tab.

2.Click the Conditional Formatting option in the Styles group and choose Manage Rules. This will invoke the Rules Manager dialog box.

3.Click on the New Rule button



4.Choose Format Only Cells that Contain

5.In the Edi t the Rule Description area, make sure the first drop down list has Cell
Value. The second drop down should be set to Less Than

6.In the formula area enter =Today () +7

7.Click the Format button and in the colour drop down choose any colour you like.

8.Here, if the due date is within the next seven days, it changes to the colour you chose. You can create one more rule and replace the formula with Today () and changing the colour to say Red, so if the date is past due it will appear red.