Forum Discussion
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...
Try:
SWITCH(TRUE(),
[Your measure] < 0.81, "red",
[Your measure] > 1.19, "red,[Your measure] >= 0.95 && [Your measure] <= 1.05, "green",
"orange")
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!
Try:
SWITCH(TRUE(),
[Your measure] < 0.81, "red",
[Your measure] > 1.19, "red,
[Your measure] >= 0.95 && [Your measure] <= 1.05, "green",
"orange")