Conditional Format Excel 2007

[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.

 

[Sheeloo]

Since Conditional Formatting is expecting NUMBERS your formula should return
numbers...
Use
=IF(L12>10%,4,IF(L12>5%,3,IF(L12>0%,2,IF(L12=0%,1))))

"1" converts the number one to TEXT.

 

[Sheeloo]

Since Conditional Formatting is expecting NUMBERS your formula should return
numbers...
Use
=IF(L12>10%,4,IF(L12>5%,3,IF(L12>0%,2,IF(L12=0%,1))))

"1" converts the number one to TEXT.

 

[Sheeloo]

I think I had responded to this earlier...

Remove the quotes around the numbers in your formula... use
IF(L12>10%,4,IF(L12>5%,3,IF(L12>0%,2,IF(L12=0%,1))))

Your formula does not take care of negative percentages.

 

[Sheeloo]

I think I had responded to this earlier...

Remove the quotes around the numbers in your formula... use
IF(L12>10%,4,IF(L12>5%,3,IF(L12>0%,2,IF(L12=0%,1))))

Your formula does not take care of negative percentages.

 

[Marilyn]

Thank you so much for the help Sheeloo.....Things are working fine now

 

[Marilyn]

Thank you so much for the help Sheeloo.....Things are working fine now