Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting €“ Due Date, Warning - Completion
I have a start date in column A
I have a due date (30 day) in column G I have a blank completion date for column G in Column H I have a due date (60 day) in column I I have a blank completion date for column I in Column J For the sake of conversation we will concern ourselves with Columns A, G and H. I will enter the start date into Column A. I would like to have Column G reflect the due date I believe I will enter the formula [=A1+30] into Column G. I would like the format color to change as I get closer to the due date: -7 Yellow -3 Red When I enter a competition date into Column H, I would like the color of Column G to return to no color. Your help will be much appreciated./Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting - Due Date, Warning - Completion
On Feb 1, 3:52*pm, TJehn wrote:
I have a start date in column A I have a due date (30 day) in column G I have a blank completion date for column G in Column H I have a due date (60 day) in column I I have a blank completion date for column I in Column J For the sake of conversation we will concern ourselves with Columns A, G and H. *I will enter the start date into Column A. *I would like to have Column G reflect the due date *I believe I will enter the formula [=A1+30] into Column G. I would like the format color to change as I get closer to the due date: -7 * * *Yellow -3 * * *Red When I enter a competition date into Column H, I would like the color of Column G to return to no color. Your help will be much appreciated./Thanks! Select cell of column G, first data column (let's say G2) then you go to Format -- Conditional Format... Then you "Formula" =and(H2="",G2-Now()<3) you format this condition in Red Then you add another and put in: "Formula" =and(H2="",G2-Now()<7) and format it yellow. hth Carlo PS: didn't test it...hope the logic is correct! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional formatting for cell date to equal today's date | Excel Worksheet Functions | |||
Conditional formatting, looking for changes in date | Excel Worksheet Functions | |||
Date stamp spreadsheet in excel to remind me of completion date | Excel Worksheet Functions | |||
Completion Percentage of a date range | Excel Discussion (Misc queries) | |||
Estimated date of completion | Excel Worksheet Functions |