Forum Discussion
Solved
Probleam: Icons in condictional formatting change with wrong cells
I have a confusing problem while trying to use icons in conditional formatting. To describe the problem clearly, I opened a new blank workbook.. I would like to use pie icons to visualize values ...
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).
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).