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?

1 Answer 1


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, 2018 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, 2018 at 6:30
  • @Frysynberg then just switch them that 1tst will be =countif({a1:e1};"no") this way you will get what you need.
    – user0
    May 24, 2018 at 11:18

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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