If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Tracking information sheet
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 |
#2
|
|||
|
|||
Tracking information sheet
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 |
#3
|
|||
|
|||
Tracking information sheet
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+6TODAY() 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 |
Thread Tools | |
Display Modes | |
|
|