Conditional Format Excel 2007

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

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top