Hi,
I tried to search but the results did not show any information.
Not sure if i did search correctly though.

I searched for conditional format and nothing came up in the search.

I am working on a sheet for a colleague.
Basically it is that i want the cell to have a color and output a text when the conditions are met.

the formula i use is this one

=IF(AND(G2="AIR"; I2<=TODAY());"Missing";"")

If G2 is AIR and I2 same or less than todays date then condition is True (missing)

I have put that formula in a cell and it works but when i copy it to the conditional format tool where you can add the formula and tell it the color to have it does not work.

Why is that?

i am rather new and i am trying to learn on my self here with excel and tiping changing the formula until it works. :-)

Apreciate your help in this matter.

Thanks in advance.

Sky