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

Avatar

Avatar
Validate 1
Level 1
Manheimer
Level 1

Likes

3 likes

Total Posts

1 post

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
Applaud 5
View profile

Avatar
Validate 1
Level 1
Manheimer
Level 1

Likes

3 likes

Total Posts

1 post

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
Applaud 5
View profile
Manheimer
Level 1

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
Coach
MVP
ursboller
MVP

Likes

525 likes

Total Posts

1,020 posts

Correct reply

257 solutions
Top badges earned
Coach
Contributor
Bedrock
Seeker
Springboard
View profile

Avatar
Coach
MVP
ursboller
MVP

Likes

525 likes

Total Posts

1,020 posts

Correct reply

257 solutions
Top badges earned
Coach
Contributor
Bedrock
Seeker
Springboard
View profile
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
Ignite 3
Moderator
jen_lasser
Moderator

Likes

116 likes

Total Posts

315 posts

Correct reply

8 solutions
Top badges earned
Ignite 3
Ignite 1
Give Back 5
Give Back 3
Give Back 10
View profile

Avatar
Ignite 3
Moderator
jen_lasser
Moderator

Likes

116 likes

Total Posts

315 posts

Correct reply

8 solutions
Top badges earned
Ignite 3
Ignite 1
Give Back 5
Give Back 3
Give Back 10
View profile
jen_lasser
Moderator

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.