Override conditional format

[Geek Girl 007]

Hi all

I have a conditional format in column H - =AND(H2<>"",EDATE(H2,3)<TODAY()) this causes the text to go red if the date is more then 3 months.
I have a conditional format in column I - =AND(H2<>"",EDATE(H2,12)<TODAY()) this causes the text to go red if the date is more then 12 months.

What I want to set up is if there is a date in column I, column H will be blank, even if i must do this by making it white??
Can you help?

 

[Kaper]

for column H (range starting H2 down): add another conditional formatting rule =ISNUMBER(I2) and set font color to white and if you open Home-> Conditional Formatting-> Manage Rules dialog make sure this one is listed above the other rule for conditional formatting of column H

 

[Geek Girl 007]

for column H (range starting H2 down): add another conditional formatting rule =ISNUMBER(I2) and set font color to white and if you open Home-> Conditional Formatting-> Manage Rules dialog make sure this one is listed above the other rule for conditional formatting of column H

Thank you !

 

[Kaper]

You are welcome. Thanks for marking answer as a solution