M
Marilyn
I have attempted to create a Conditional Format with Icon Sets in my Excel
2007 workbook; however, the Icon Sets are not appearing. The column that I’m
working with has the following formula:
IF(L12>10%,"4",IF(L12>5%,"3",IF(L12>0%,"2",IF(L12=0%,"1"))))
When creating the Icon Set Conditional Format I have selected Formula and
Number from the Type field, however, the Icon Sets are still not present.
Some of the cells return a #DIV/0 error and I have removed those, however, I
still don’t see the Icon Sets. The only way I have been able to get the
desired results is by copying the contents and pasting just the VALUES then
formatting the cells to Number, however, I need the formula so that the cells
can update accordingly.
Any Help is always appreciated.
2007 workbook; however, the Icon Sets are not appearing. The column that I’m
working with has the following formula:
IF(L12>10%,"4",IF(L12>5%,"3",IF(L12>0%,"2",IF(L12=0%,"1"))))
When creating the Icon Set Conditional Format I have selected Formula and
Number from the Type field, however, the Icon Sets are still not present.
Some of the cells return a #DIV/0 error and I have removed those, however, I
still don’t see the Icon Sets. The only way I have been able to get the
desired results is by copying the contents and pasting just the VALUES then
formatting the cells to Number, however, I need the formula so that the cells
can update accordingly.
Any Help is always appreciated.