Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Conditional formatting for matrix visualization

Hello ,   Pleasee I need to exclude a range of digits in conditional formatting for matrix visualization but i don't know how i can do it !!! In this Matrix visualization, I want to exclude the fo...
Need Help
mlsx4's avatar
mlsx4
Memorable Member
3 years ago

Hi Anonymous 

 

You just need to colour the range you want to include

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Thank you for your response, but I actually need the data to be automatically colored and graded according to their values (for example, if it's a max value, it should be colored red, otherwise green, or if it's close to max, it should be colored more or less close to red...).

     

    • mlsx4's avatar
      mlsx4
      Memorable Member
      3 years ago

      Hi Anonymous 

       

      And why don't you use gradient rules? Instead of simply rules

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Hi mlsx4 ,

        Since I'm updating data simultaneously, I can't define rules for number intervals (max, min, medium..) . 

        And I want the degree of color to change with each number