condition format not working

hi  Anonymous 

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" 

Regards,

Lin