Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Does Conditional Formatting Work on All Columns When Setting Custom Limits ?

Manheimer
Level 1
Level 1

I have selected multiple columns in a Workspace freeform table and applied Conditional Formatting

By default all rows in all columns receive formatting when the Conditional Formatting is set to Auto-generated

When switching the limits to Custom, only the header rows receive Conditional Formatting

1 Accepted Solution
Urs_Boller
Correct answer by
Community Advisor
Community Advisor

This "works as designed", means if you select "auto-generate" it will look at each column seperately, detect high/low and add color. same happens to breakdowns where it calculates the new high/low (high/low based of the breakdown of a single column!)

but when you change formatting to "custom", it will take the high/low only for the first level, not for any breakdowns you have. I guess the reason is that it there are a lot of cases where the custom high/low doen't make sense and would mess up the picture ...

jen.lasser​ are there any ideas/plans to change this?

View solution in original post

4 Replies
Urs_Boller
Correct answer by
Community Advisor
Community Advisor

This "works as designed", means if you select "auto-generate" it will look at each column seperately, detect high/low and add color. same happens to breakdowns where it calculates the new high/low (high/low based of the breakdown of a single column!)

but when you change formatting to "custom", it will take the high/low only for the first level, not for any breakdowns you have. I guess the reason is that it there are a lot of cases where the custom high/low doen't make sense and would mess up the picture ...

jen.lasser​ are there any ideas/plans to change this?

View solution in original post

jen_lasser
Moderator
Moderator

Urs is correct. Conditional formatting only applies to breakdown rows when "auto" is selected. We disable conditional formatting for "manual". We have a backlog item to address this, no release date yet though.

kelseypedersen
Level 2
Level 2

Hi Jen - Is there anywhere that we can possibly vote for this feature? All of our business reporting looks at green as positive, and red as negative, so we use conditional formatting to obtain that. Would love to be able to show results by region and country utilizing the breakdown with conditional formatting!

abhinavc101
Level 2
Level 2
Hi Jen - Thanks for the clarification. Is there any plan/roadmap to release this complete custom conditional formatting solution for 'manual' ? Let us know if we(as customers) can vote for this feature? We have seen that the 'auto' formatting seem to be a bit confusing at times & max./min. distribution do not seem to look appropriate all the time. Thanks!