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

Avatar

Avatar

Manheimer

Avatar

Manheimer

Manheimer

13-03-2019

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

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

ursboller

MVP

Total Posts

1.0K

Likes

484

Correct Answer

250

Avatar

ursboller

MVP

Total Posts

1.0K

Likes

484

Correct Answer

250
ursboller
MVP

14-03-2019

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?

Answers (1)

Answers (1)

Avatar

Avatar

jen_lasser

Employee

Avatar

jen_lasser

Employee

jen_lasser
Employee

14-03-2019

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.