Conditional Formatting - All Columns at once?

[misiek5510]

Hi guys. Is there a way to copy or apply same conditional formatting for multiple columns. (about 40 columns)?

 

[Joe4]

Not sure if you meant to post this in the "Power BI" forum instead of the "Excel Questions" forum, or that was just accidental.

But you can apply a single Conditional Formatting Rule to a WHOLE range of values at once pretty easily.
Just select the entire range you want to apply it to, and enter the Formatting rule as it applies to the very first cell in your selection.
Excel is usually smart enough to adjust it for all the other cells in the range.

If you are having trouble doing this, tell us the range you are applying it to, and what the rule should be.

 

[misiek5510]

Hi Yes, I did mean to post it in Power Bi section In the Matrix visual I've added 40 different values which are columns in the martix however I have to apply conditional formatting to it individually. (40 times) is there an solution where I can copy the exact same formatting for all values / columns ?

 

[Joe4]

I admit that I do not use Power BI, but in my Google Searches, all the issues that I see seem to be that people say it defaults thw whole matrix, when they just want a single column (so maybe the exact opposite of what you are trying to do). Do these 40 columns represent the entire matrix?

If not, the only thread I found that seems to address that scenario seems to imply that you have to do each one manually:

Conditional Formatting on multiple columns in a table

I able trying to apply the same conditional formatting to 20 columnts in a table without configuring each column. Format Painter doesn't seem to work. Below is a sample of DAX Measure. Is there a way to write this so that 'Capability'[People]' could be generic to cover the other 19 fields...

community.powerbi.com

 

[misiek5510]

thank you for your reply. Yes, i did find the same, however was hoping someone came with a solution