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.
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.
That did the trick! The formula in the source table asked for the value to be “1” instead of 1. Once I changed that, the icons appeared immediately. It’s amazing how the data remains the same through so many different processes. There was the source table, then the PivotTable, and finally a third table where I wanted the icons. Thank you for the help!
Charlespower74 , you are welcome, great to know you sorted this out.