Forum Discussion
Probleam: Icons in condictional formatting change with wrong cells
That's since you took percent as the type. Excel takes entire range and calculates for the cell value in which % it within the range. If to apply icon only based on concrete cell value select Number as type and set values as 0.8, 0.6, 0.4, 0.2 in your rule.
Type is not connected to the format you apply to your cells (%, date, whatever).
Hey CathySong
Also, I don't think that your conditional format works even when all the cells are filled since 80% shows a three-quarter filled cell, but I think you wanted it to show a fully black circle.
What you can do to fix this is that change your data type back to General, and it should come up with 0.1, 0.2, etc.
Then Edit Formatting Rule options, Change the Type from percentage to Number:
Then just reformat the column back to the data type Percentage
I kept the format setting in the cells and adjusted settings as shown below, it works well. :-)