Color above and below 10% conditional formatting

[poweruser55]

I am try to coniditonally color formata matrix. When the % is equal or above 10, I want the color to be green. WHen it is equal or below -10% I want it to be red. All else white. This is what I tried but couldn't get it.

[V-lianl-msft · Accepted solution]

Hi @poweruser55 ,

Try to create rule like below:

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.