Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Conditionnal formatting not working properly

Hi,

 

I have the following bar chart :

I want to color all bars above 80% green and the rest red. My rule in conditionnal formatitng is the following :

So why aren't all bars above 80% green ? What haven't I understood or what isn't working right ?

 

Thanks

James

 

 

Need Help
  • AntonioM's avatar
    AntonioM
    4 years ago

    Hi, 

     

    The percent option in the conditional formatting is not the same as your percentage values. If you change them to number then it should work. 

     

3 Replies

  • AntonioM's avatar
    AntonioM
    Icon for Solution Sage rankSolution Sage
    4 years ago

    Hi, 

     

    The percent option in the conditional formatting is not the same as your percentage values. If you change them to number then it should work. 

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      It work fine! I have been struggling all morning. Thanks a lot.

       

      Would you care to explain what the percentage in conditionnal formatting represents ? It's relative percentage so above 80% means the top 20% of all values or something like this ?

      • AntonioM's avatar
        AntonioM
        Icon for Solution Sage rankSolution Sage
        4 years ago

        To be completely honest I'm not 100% sure. I know it's not just the percentage of the highest value, which is why it doesn't do what you might expect, but I've never looked into what it does exactly.