Forum Discussion
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 ...
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.
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.
Hi Anonymous , I have changed the rule for Orange:
However, it still remains black.