Expand my Community achievements bar.

Join us for the next Community Q&A Coffee Break on Tuesday April 23, 2024 with Eric Matisoff, Principal Evangelist, Analytics & Data Science, who will join us to discuss all the big news and announcements from Summit 2024!

Conditional Formatting: Positive or Negative values

Avatar

Level 4

6/21/23

The settings for Conditional Formatting don't allow for what I want: a simple two-color scheme - positive all green, negative all red.

Even turning off the auto-generate and putting 0 for the midpoint, AA still calculates ranges based on values. Here, the highest value, 6,443 is so far above the others that it assigns it green, but then plus 36 and minus 36 have the same color because they're relatively closer. Setting the max, mid, and min values to +1, 0, and -1 gets closer to what I want, but still shows plus 6 and minus 4 values as the same color. This is trivially easy to do in Excel....

Screenshot - 6_21_2023 , 12_19_03 PM.png

Screenshot - 6_21_2023 , 12_27_12 PM.png

Screenshot - 6_21_2023 , 12_27_27 PM.png

Screenshot - 6_21_2023 , 12_30_52 PM.png

    

3 Comments

Avatar

Community Advisor

6/21/23

You can get a 2 colour scheme (or well.. 3 colour scheme if the value is exactly 0%)... the problem with your settings is that your column is in percent (100% is "1" and -100% is "-1") so all the % are falling between your min and max....

 

 

Jennifer_Dungan_0-1687390235897.png

 

Or use "percent limits", rather than decimal:

Jennifer_Dungan_1-1687390480661.png

 

 

You just have to adjust your scale to work better with your values...

 

 

I just threw some fake values in to show a Proof of Concept:

Jennifer_Dungan_0-1687390563064.png