Forum Discussion
BarneyRubble
1 year agoNew Member
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 belo...
BarneyRubble
1 year agoNew Member
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.