Issue on Conditional Formatting

[Anonymous]

The conditional formatting is only working on 1 column %Returned, it does not work at all in the other matrix, however, the colors are correct when I drill down. See screen shot below.

[v-lili6-msft · Accepted solution]

hi @Anonymous 

First,The conditional formatting is only working on 1 column %Returned, it does not work at all in the other matrix, You only do the the condition format for this column, so it will only work on that column, you could do the condition format for each column and Based on field is [%SigVerified].

Second, you must know that the way the "Percent" conditional formatting works is different than you think, it doesn't have anything to do with percent of total.  It take the lowest and hightest displayed amounts and uses those to determine the formatting bands based on the Percent you entered so your table is looking at these numbers to apply the formatting.

So for your case, just replace "Percent" with "Number" and use 0.51/0.81/1 instead as below:

Regards,

Lin

[Anonymous]

Thank you very much for pointing the way "Percent" works in conditional formatting. By changing it to "Number", the colors are now showing correctly.

[amitchandak]

Hope the values are not coming as blank/null in first case. In second case all values are 0

[Anonymous]

I understand the zeros but the others do not have correct color, below is my rule.