Format multiple columns in one rule

[SKETCHwade]

Is there an easy way to format all columns if they contain specific text?
I have tried in a way I think should work but it instead formats all columns if one column contains this text.

Example of my formula,

IF(OR([External E Stops] = Requires Immediate Attention,
[Tyres / Rims / Wheel Nuts] = Requires Immediate Attention,
[Pins & Bushes] = Requires Immediate Attention,
[Cylinder & Hoses] = Requires Immediate Attention
),False,True)

The reason this does’nt work is due to the fact it then formats all columns together as one. Can this be modified?

Otherwise I will have to make over 100 format rules haha

[Aleksi · Accepted solution]

I’m afraid you need to add them one by one.

[SKETCHwade]

Ok, thank you

[dostoevsky]

Just checking: Is this still the case?
In my app, I’ll need to add several hundred. The columns are all Enum using the same options across the table.

[Marc_Dillon]

It is.

[Marco_Abuid]

just checking two years after... is this still the case?

[Steve]

No change.

[ConorO]

Still can't believe this isn't a feature yet. But I'm in a similar situation and thought I'd pass along a tip that made my life slightly easier - if your formula rules are related, use a table to autogenerate the rule title, formula, custom text color (for me), etc. for each rule. Copy previous rule, copy/paste the new fields, rinse and repeat

[ADRN]

I think it is working already, am I correct? 
You just have to use OR() (without IF() ) in formula and choose columns which should be formatted based on the rule. 

[Oscarfotz]

I wish, but no. It only takes one true condition for the OR() to evaluate to true, which means the formatting applies to all selected columns.

[mika134]

Indeed it would be great to have a better solution for this. I created a safety questionnaire with ~50 questions. Now I want to highlight as soon as any answer is "Yes". So at least for yes/no questions it would be great to have a possibility to say "Yes = red, No = green" for all columns... 😞

[Marco_Abuid]

Come on beloved Devs.. gave us this feature.... my last post was 2 years ago.. and the opening post is from 5 years ago!.... god its older than my lil kid.

[MiguelPilo]

I think I have an idea but I need you to share a screenshot of the view in which you require the conditional formatting to analyze how they present the information and corroborate that it is possible 

[Marco_Abuid]

just think in a table view with 10 cols of yes/no type, what we want if one rule that checks for the result whatever the column its been evaluating. and according to that apply some format. the thing is that today we must create the expresion using as reference one col to evaluate, so it forces to make one by one colum, else all the columns will change acording to the value of the one tha has been evatuated.