Conditional Formatting – Due Date, Warning - Completion

[TJehn]

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.

 

[FSt1]

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