Hi,
Here are two ways:
1. Let's suppose the Entered Date is in column A starting on row 2. In cell
B2 enter the formula =A2+6 and copy it down, this is the due date column.
2. Select all the rows you want to format and
In 2003:
1. Select the cells you want to format
2. Choose Format, Conditional Formatting
3. Choose Formula is from the first drop down
4. In the second box enter the formula:
=$B2<=TODAY()
5. Click the Format button
6. Choose a color on the Patterns tab (or any available option)
7. Click OK twice.
In 2007:
1. Highlight all the cells on the rows you want formatted
2. Choose Home, Conditional Formatting, New Rule
3. Choose Use a formula to determine which cell to format
4. In the Format values where this formula is true enter the following
formula:
=$B2<=TODAY()
5. Click the Format button and choose a format.
6. Click OK twice
Method 2
In this example your Entered dates are in column A again but there is no
formula in column B. Highlight all the rows you want to format and use the
steps above but change the formula to
=$A2+6<TODAY()
Note you have stated you want to flag them at +6 days at which point they
are really one day short of a week, so maybe not past due? But all you need
to do is change the +6 to +7 or whatever.