I have a questionnaire with 10 Y/N questions, when my staff review the questionnaire answers I want to be able to hightlight Yes answers to GREEN and No answers to RED.
Is there an expression which I can use for all 10 question fields or do I need to have a Yes rule and No rule for each of the 10 questions (20 rules in total) ? eg.
If question 1 is Yes, then format GREEN
If question 1 is No, then format RED
If question 2 is Yes, then format GREEN
If question 2 is No, then format RED
โฆ
User | Count |
---|---|
43 | |
26 | |
25 | |
16 | |
13 |