I am creating a sheet for tracking outcomes. I want to put the information
into the sheet with a due date for outcomes. e.g data entered [today],
outcome due [7 days later] when the due date arrives I want the row to change
colour, so that anyone reading the sheet is alerted to the overdue outcome
and can deal with it. Any ideas?
--
Kind regards Juliebee

Hi,

In this example the due date goes in column G and row 1 is the top row.
Select the rows to which this applies then

Format|Conditional format - Formula is

enter the formula

=AND($G1<"",$G1<=TODAY())

Pick a colour - OK


chage the column to your column and the 1 to your top row

Mike

"Juliebee" wrote:

I am creating a sheet for tracking outcomes. I want to put the information
into the sheet with a due date for outcomes. e.g data entered [today],
outcome due [7 days later] when the due date arrives I want the row to change
colour, so that anyone reading the sheet is alerted to the overdue outcome
and can deal with it. Any ideas?
--
Kind regards Juliebee

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.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Juliebee" wrote:

I am creating a sheet for tracking outcomes. I want to put the information
into the sheet with a due date for outcomes. e.g data entered [today],
outcome due [7 days later] when the due date arrives I want the row to change
colour, so that anyone reading the sheet is alerted to the overdue outcome
and can deal with it. Any ideas?
--
Kind regards Juliebee