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:


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?


yes you can but its unclear if you need that for whole range or just for one ocurance so the answer depends...

but this are the custom formulas in conditional formatting in F1:

  • Why not just a1:e1? – TheMaster May 18 '18 at 12:36
  • Sorry I was being vague. "=countif({a1;b1;c1;d1;e1};"yes")" or "=countif({a1:e1};"yes")" does work, But is there a was to say =countif({a1:e1};"yes") but if ANY in A1:E1="no" then format for red – Frysynberg May 24 '18 at 6:30
  • @Frysynberg then just switch them that 1tst will be =countif({a1:e1};"no") this way you will get what you need. – MARK MY ANSWER May 24 '18 at 11:18

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.