Format Rules for multiple fields

[jeffchoy]

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
…

[Rifad]

Red and green when condition is YES ?

[jeffchoy]

Sorry, typo. I have corrected it now

[Suvrutt_Gurjar]

I believe

1. You will need twenty format rules if the format rules also include icons such as check mark or cross mark

The below is just for academic interest of a marginally lesser efforts workaround

2. If the format rules are only for text colours without icons, then you may try with 11 format rules.

A) One common format rule for all 10 fields for all Yes values in green colour with an expression such as OR([Q 1], [Q 2], …[Q 9], [Q 10]) and

B) Individual format rules for each column in red colour with an expression such as NOT([Q 1])

Did quick testing for option 2 above and it works. Please test well.