Forum Discussion
Conditional Formatting
Hi all,
I want to ask why my conditional formatting is not working. This is my matrix and the conditional formatting. The orange arrow should be in green as it exceeds 15%. Thank you so much.
Anonymous
try to compare with Number, not Percent
8 Replies
Hi Anonymous
there are much more in Conditional Formatting dialog box, please show.
Bytheway, I see your last row has Number as Unit, not percent. Im not sure it will work correct
Hi az38, here is the full conditional formatting dialog box. The number at the end of the condition does not affect the icon/colors even if I remove it. I've tried it before w/o the last condition and it still doesn't work. The only problem is the numbers greater than 15 are marked as orange icon while it should be green icon.
Anonymous
what is [GP Growth %] field? is it a measure? do you use CALCULATE()?
and do you like green arrows in values like 900%? your rule should cut it off