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!