Icon sets.

[laxaterine]

Good evening, i have problem with Conditional formatting icon sets. I use basic dots (green, yellow and red). If percentage is more or equal than 80 its green, if percentage is less than 80 and more or equal than 40 its yellow, and if percentage if less than 40 its red. But when I apply the formmating rule on cell, on example i have 55% I get green dot, i should get yellow, can you help me with this.

 

[JamesLoft]

Hello, I seen this problem in forum. You should try to change the type of rule to number instead of percentage, and write not 80%, but number 0.80, and same to other did it helped?