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 following interval [0...5000] so that it's not colorized

 

 

Thanks in advance

Need Help

4 Replies

  • 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