Conditional Formatting to apply to two cells

[c.drysdale89]

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

[benishiryo]

hi Claire, the $ sign matters. in case you have done any steps wrong, i'll go through the whole process. select the range you want to apply to (eg E3:F10)
go to Home -> Conditional Formatting -> New Rule -> Use a formula to determine which cells to format -> Format values where this formula is true:
=AND($E3=”Yes”,$F3 =”Yes”)

this means that in E3, it compares E3 & F3. it then copies the formula over to F3. but because i use the dollar signs, it still compares column E & F. your formula would cause it to become:
=AND(F3=”Yes”, G3 =”Yes”)

[etaf]

Sorry, had open before benishiryo posted

try
=AND($E3=”Yes”, $E3 =”Yes” and copy to all the cells needed

did you mean to compare E with F in your example ?

see attached