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. |
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. |
All times are GMT +1. The time now is 12:38 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com