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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting €“ Due Date, Warning - Completion
hi
see if this will work for you. condition 1. if formula is...=IF(AND(H2="",G2=NOW()-3),1,0)...red condition 2 if formula is...=IF(AND(H2="",G2=NOW()-7),1,0)...yellow regards FSt1 "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. |
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 €“ Due Date, Warning - Completion | Excel Discussion (Misc queries) | |||
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 |