Background colour - Conditional Formatting

[adam_macs]

Hi, i have a measure that tracks sales against a target and i would like the background color to change to:

• green if greater than the target
• red if less than the target
• amber if within 5% of the target

Is it possible to do this within conditional formatting box or does a new measure have to created? I have no idea where to start by applying this logic to the conditional formatting. 

[Hariharan_R · Accepted solution]

Hi,

if you have static values to define the conditional formatting colors then you can use GUI like your screenshot but if you want to compare two different measures or values then you need to use measure and use that measure on the conditional formatting.

Thanks

Hari