Does Conditional Formatting Work on All Columns When Setting Custom Limits ? | Community
Skip to main content
M
Manheimer
Level 1
March 13, 2019
Solved

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

  • March 13, 2019
  • 2 replies
  • 6798 views

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

    Best answer by Urs_Boller

    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?

    2 replies

    Urs_Boller
    Community Advisor
    Urs_BollerCommunity AdvisorAccepted solution
    Community Advisor
    March 14, 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?

      J
      Adobe Employee
      JenLa5Adobe Employee
      Adobe Employee
      March 14, 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.

        kelseypedersen
        kelseypedersen
        Level 2
        April 1, 2020

        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!

          Terms & ConditionsAccessibility statement

          Loading footer...