Conditional formatting

[overmyhead1]

I have conditional formatting (using color circles) in the H column for deadline dates. Green is greater than 15 days out. Yellow for 15 days or less and red for due date and overdue. All set with today value. Is there a way to turn off the conditional formatting once a date is entered into the I column?

 

[Joe4]

What is your current Conditional Formatting rule?
Are you using a formula?

If so, then you just need to expand upon that formula to also check that column I is blank, i.e.

=AND(I2="",your current formula)

 

[overmyhead1]

What is your current Conditional Formatting rule?
Are you using a formula?

If so, then you just need to expand upon that formula to also check that column I is blank, i.e.

=AND(I2="",your current formula)

Sorry I am new to excel. This is what I have H set at (see picture). I don't know of other ways to set the conditional formatting.

 

[Joe4]

You will want to change to the last option, "Use a formula to determine which cells to format", and then use a formula for your Conditional Formatting rule.
If the first row you selected for your Conditional Formatting is row 2, your first CF formula would look something like:

=AND(I2="",H2>=TODAY()+15)

and then you would choose your desired formatting option (green).

And your other formula might look something like:

=AND(I2="",H2>=TODAY(),H2<TODAY+15)

and then choose your desired formatting option (red).