May 22 2020 12:49 PM
May 22 2020 12:53 PM
May 22 2020 01:05 PM
SolutionIn 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.
May 23 2020 10:37 AM
May 23 2020 11:35 AM
@Charlespower74 , you are welcome, great to know you sorted this out.
May 22 2020 01:05 PM
SolutionIn 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.