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:

| improve this answer | |
  • 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. – user0 May 24 '18 at 11:18

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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