Forum Discussion
Solved
Conditional formatting icon sets aren’t working
I have a column I would like to conditionally format by adding icons to the cells. The data in each cell is simply a number from 1 to 5. When I try to apply the conditional formatting rule, nothing ha...
In general formatting rule doesn't care how values appeared in the range cells.
Icon could not appear if you apply the rule to text values, are you sure the range definitely have numbers, not the texts which present numbers? Other words, what returns =ISTEXT() on such cells.
Select the range and click on Icon Set conditional formatting.. Then, you can modify the rule to what you need