cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Conditional Formatting ALL columns instead of each individual

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Conditional Formatting ALL columns instead of each individual

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

3 REPLIES 3
Highlighted
Super User V
Super User V

Re: Conditional Formatting ALL columns instead of each individual

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

Highlighted
Community Support
Community Support

Re: Conditional Formatting ALL columns instead of each individual

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

Highlighted
Frequent Visitor

Re: Conditional Formatting ALL columns instead of each individual

ll try that out.  thanks.

Helpful resources

Announcements
Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Upcoming Events

Community Summit North America – Join Online!

Join this community-driven Power Platform digital event for unbiased support and problem-solving.

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.