Conditional Formatting ALL columns instead of each individual

[common763]

I have about 10 values in a Matrix Table.   I want to color code all and the rules are the same for all ten columns.  Do I have to individually go in and type the rules in for all 10?  I did that for one table but dont want to keep doing it for others if I can just apply one set of rules to all ten separate columns.  Is there a way to do this?

Right now I go into Conditional formatting, select COLUMN1, write the rules, then go to COLUMN2 and write the same exact rules.  It is time consuming.  It could be staring at me but I dont see anything in the drop-down to select all under conditional formatting.

[v-shex-msft · Accepted solution]

Hi @common763,

If your table exists multiple value fields, you can consider unpivot them to attribute and value.

Unpivot columns (Power Query) 
Then you can modify your conditional formatting formula to calculate based on its attribute category and apply color formatting on the value field, it should reduce these duplicate operations.

Regards,

Xiaoxin Sheng

[common763]

ll try that out.  thanks.

[lbendlin]

Nice idea - see if someone has already raised it. If yes, vote for it. if no, create it.