This should be easy, but i just cant get it, Grrrr.

I have attached the sample. I need the cells without the employee or without a boss to highlight a color and i also need the date of certification to highlight if it is more than one year old.


Thanks.


conditional formatting.xlsx