I have a table that I have manually created, which has Yes/No answers.
I need to apply the conditional formatting to the cells to show if it "Yes" and "Yes" = Green, "Yes" and "No" = Amber, "No" and "No" = Red.
I thought I had created it and applied it to the whole table but it didn't seem to work (for example, I used =AND(E3=”Yes”, F3 =”Yes”) to make the two cells green).
Could anyone suggest a different way to do this?
Do we have this? Signed by customer?
No........................No
Yes........................No
Yes........................Yes
Thanks,
Claire
Bookmarks