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.
|