If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Conditional Format Excel 2007
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(L1210%,"4",IF(L125%,"3",IF(L120%,"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. |
#2
|
|||
|
|||
Conditional Format Excel 2007
Since Conditional Formatting is expecting NUMBERS your formula should return
numbers... Use =IF(L1210%,4,IF(L125%,3,IF(L120%,2,IF(L12=0%,1) ))) "1" converts the number one to TEXT. "Marilyn" wrote: 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(L1210%,"4",IF(L125%,"3",IF(L120%,"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. |
#3
|
|||
|
|||
Conditional Format Excel 2007
I think I had responded to this earlier...
Remove the quotes around the numbers in your formula... use IF(L1210%,4,IF(L125%,3,IF(L120%,2,IF(L12=0%,1)) )) Your formula does not take care of negative percentages. "Marilyn" wrote: 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(L1210%,"4",IF(L125%,"3",IF(L120%,"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. |
#4
|
|||
|
|||
Conditional Format Excel 2007
Thank you so much for the help Sheeloo.....Things are working fine now
"Sheeloo" wrote: I think I had responded to this earlier... Remove the quotes around the numbers in your formula... use IF(L1210%,4,IF(L125%,3,IF(L120%,2,IF(L12=0%,1)) )) Your formula does not take care of negative percentages. "Marilyn" wrote: 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(L1210%,"4",IF(L125%,"3",IF(L120%,"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. |
Thread Tools | |
Display Modes | |
|
|