Forum Discussion

Caiz's avatar
Caiz
Frequent Visitor
5 years ago
Solved

Conditional Formatting Logic in Matrix based on Variance

I'm trying to do conditional formatting with a traffic light column in my matrix. This is what the traffic light is based on: 0-5% variance = GREEN 6-10% variance = ORANGE 11%+ variance =RED   ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Caiz ,

     

    If value is less than -0.06 means value <-0.06 not value <= -0.06. You can try to set if value is less than -0.055.

     

     

    Best Regards,

    Stephen Tao

     

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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Caiz ,

 

I made a number axis chart. As you can see in the figure, -0.06 is not within the condition range, so it is black.

 

 

Best Regards,

Stephen Tao

 

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

  • Caiz's avatar
    Caiz
    Frequent Visitor
    5 years ago

    Hi Anonymous , I have changed the rule for Orange:

    However, it still remains black.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi Caiz ,

       

      If value is less than -0.06 means value <-0.06 not value <= -0.06. You can try to set if value is less than -0.055.

       

       

      Best Regards,

      Stephen Tao

       

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