Undo conditional formating if data is entered in cell

I'm stuck....

I have two colums I and J. I is going to be filled with the date a product is ordered and J with the date the product is delvered to us.

In J I have the conditional format that if the data in I is older than two weeks it turns red. So we know when to call the company that our goods haven't arrived yet. =(VALUE(I11))<VALUE(TODAY())-14

Now I need to add a conditional format that if there is a date entered in J, so that means the product has been delivered to us. the cell isn't red any more, so the conditional format I entered does not apply anymore or the cell chnges blank if a date is entered. I don't mind as long as the cell isn't red.

Thanks for the help!!! I'm happy to explain further if needed.

eMeLI

Hi Erik,

Thanks sooooo much!!! That works perfectly :D

I had one more question...is it also possible to not have the cells in J be colored red if there is nothing entered in I?

Thanks,

eMeLI

Erik,

Unfortunately now it doesn't turn red at all anymore :O Unless there is nothing filled in :D

Thanks for trying...

eMeLI

hi, eMeLI, please check attachment