Conditional formatting with a formula

[28creation]

Hi all,

I need to make a cell a certain colour based on the outcomes of two other cells....

One cell has a date in. This is the date certain training has to be completed by.

The other has a Yes or No in. This is to indicate if the training has been done.

The third cell, where the colour changes based on these two cells, is to recognise if the training has been completed by the date in the first cell, so it goes green. If it hasn't then it goes red.

Hope to hear from someone soon regarding this.

Thanks in advance,

Matt

 

[oldbrewer]

first condition =and(a1<today(),b1="no")...............set to red
second condition =b1="yes" ...................................set to green

this will not pick up if training was completed late

 

[28creation]

first condition =and(a1<today(),b1="no")...............set red
second condition =b1="yes" ...................................set to green

this will not pick up if training was completed late

Thank you very much!! Knew it was something quite straight forward, just couldn't get it to work. Cheers.
</today(),b1="no")...............set>

 

[oldbrewer]

well done you decoded the forum treatment of < and >