Forum Discussion

poweruser55's avatar
poweruser55
Helper IV
4 years ago
Solved

Color above and below 10% conditional formatting

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.

Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    4 years ago

    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.

1 Reply

  • V-lianl-msft's avatar
    V-lianl-msft
    Community Support
    4 years ago

    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.