Forum Discussion
Conditonal formatting not applying correct on matrix table
Hello I have been trying to figure out what is wrong with my matrix table, I am trying to use conditional formatting to highlight values above average red and values below average green.
Here is the conditional formula
Anonymous
avoid percentages and use this way to get right result
if value >= 0 per cent and < any number
if value >= any number and < any number
if value>= any number and <= max
2 Replies
Anonymous
avoid percentages and use this way to get right result
if value >= 0 per cent and < any number
if value >= any number and < any number
if value>= any number and <= max