Conditional formatting for matrix visualization

[Anonymous]

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

[mlsx4]

Hi @Anonymous 

You just need to colour the range you want to include

[Anonymous]

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]

Hi @Anonymous 

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

[Anonymous]

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