- Dec 29, 2016
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.