Conditional Formatting- Positive & Negative Variances

[BarneyRubble]

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.

[Greg_Deckler]

@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.

[Deku]

Rules look like this

[BarneyRubble]

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.