Forum Discussion
Conditional Formatting- Positive & Negative Variances
Hi,
I am wondering if it is possible to do RAG status formatting based on a range of variances.
Any positive variance = Green
Negative variance zero to minus 5 = Amber
Negative variance below minus 5 = Red
I know how to do just the Red & Green but I don't know how I include the Amber.
3 Replies
BarneyRubble There is a setting to include a third color for gradients in conditional formatting. That's one way or you can do rules and do it that way or you can create a measure that returns the correct color hex code.
Rules look like this
Hi, Thanks for responding. I probably should have provided more details in my initial post. The visual I am using is the MS KPI, it is based on Actual v Budget. The default is Green for a positve variance (actual is lower) and Red for a negative variance (actual is higher). I have highlighted the variance in the snip below. What I want to do is maintain the Green for any positive variance so from 0 - 100, I would like a negative variance between 0 to -5 to be Amber, then anything below -5 to be Red. I hope that makes sense.
