Does Conditional Formatting Work on All Columns When Setting Custom Limits ? | Community
Skip to main content
Manheimer
Level 1
Mar 13, 2019 6:50 PM UTC
Solved

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

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

    Urs_Boller
    Urs_BollerAccepted solution
    New Participant
    Mar 14, 2019 4:46 PM UTC

    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 reply

    4 replies

    JenLa5
    Employee
    Mar 14, 2019 5:12 PM UTC

    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.

    Translate
      kelseypedersen
      kelseypedersen
      Level 2
      Apr 1, 2020 6:22 PM UTC

      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!

      Translate
        Urs_Boller
        Urs_BollerAccepted solution
        New Participant
        Mar 14, 2019 4:46 PM UTC

        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?

        Translate
          Terms & ConditionsAccessibility statement

          Loading footer...