I have 5 cells (A1:E1) that are filled with either 'yes', 'no', or 'maybe'. Can I have conditional formatting on F1, where if 'yes' is green, and if 'no' is red?
To clarify:
=countif({a1:e1};"yes")
can format my last field for a green, but is there way to have that, but in addition format for ANY in A1:E1="no" then format for red instead?