Forum Discussion

deanbland's avatar
deanbland
Helper III
5 years ago
Solved

Help with conditional formatting!

HI,    I have a matrix table (shown below) and I am wanting to conditional format the cells within each column in the following way:    - Between -5 and +5, they are highlighted Green - Above +5...
Need Help
Tips and Tricks
  • PaulDBrown's avatar
    PaulDBrown
    5 years ago

    deanbland 

    Try:

    SWITCH(TRUE(),

    [Your measure] < 0.81, "red",
    [Your measure] > 1.19, "red,

    [Your measure] >= 0.95 && [Your measure] <= 1.05, "green",
    "orange")

VijayP's avatar
VijayP
Community Champion
5 years ago

deanbland 

You need to create a Measure

SWITCH(TRUE(),
YourMeasure>= -5 && YourMeasure <=5, "Green",
YourMeasure<=-19&&YourMeasure>=19 ,"#DC8210", "red")

Then use this In conditional Formatting using Field Value

as shown below:

Please let me know if any questions

deanbland's avatar
deanbland
Helper III
5 years ago

Hi, 

 

Thank you for responding. When using the measure suggested above, it doesn't work as expected. 

 

 

It is turning every number green. I have tried changing the measure with no luck. It seems to constantly highlight all numbers green, regardless of their value. 

 

I am wanting everything between -5% and +5% green and everything below -19% and above 19% red. 

 

Thanks again!

 

  • PaulDBrown's avatar
    PaulDBrown
    Community Champion
    5 years ago

    deanbland 

    Try:

    SWITCH(TRUE(),

    [Your measure] < 0.81, "red",
    [Your measure] > 1.19, "red,

    [Your measure] >= 0.95 && [Your measure] <= 1.05, "green",
    "orange")