Tracking information sheet

  • Thread starter Thread starter Juliebee
  • Start date Start date
J

Juliebee

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?
 
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
 
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.
 
Back
Top