Forum Discussion

Ausar's avatar
Ausar
Helper I
2 years ago

Conditional formatting on columns does not work correctly

Hi everyone,

Could someone tell me why conditional formatting works incorrectly?

  • Value between 0 and 5: green color
  • Greater than 5 and less than 10: light red
  • Above 10 and below 100: red

     

     

 

 

Need Help

5 Replies

  • Syk's avatar
    Syk
    Resident Rockstar
    2 years ago

    Try switching all of the selection boxes to % instead of number.

    If value >= 0 Percent and <= 5 Percent then green

  • Kaviraj11's avatar
    Kaviraj11
    Solution Sage
    2 years ago

    Hi,

     

    It seems like you have the mismatch unit in the condition as shown below. Please correct it with unique and single unit either Number of Percent.

     

    Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!

    • Kaviraj11's avatar
      Kaviraj11
      Solution Sage
      2 years ago

      Can you show what measure did you use in the chart? Need to understand the calcualtion behind that.