Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel: Having more than 3 conditional formats would be helpful.
In Excel, I have a series of formulas that outputs one of six results....
let's say 1, 2, 3, 4, 5, and 6 (for simplicity). I would like to assign a color to each of the results of the formulas. So 1 would be blue, 2 would be green, etc. Excel limits me to 3 conditional formats therefore I can not do the above. It would be helpful is Excel did not limit the number of conditional formats one can impose on a cell. Thanks! ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel: Having more than 3 conditional formats would be helpful.
XL 2007 allows up to 64 conditional formats. It is slated for general
release in early 2007, and is available now as a beta download, for a nominal charge. Dave -- Brevity is the soul of wit. "Lee Ellen" wrote: In Excel, I have a series of formulas that outputs one of six results.... let's say 1, 2, 3, 4, 5, and 6 (for simplicity). I would like to assign a color to each of the results of the formulas. So 1 would be blue, 2 would be green, etc. Excel limits me to 3 conditional formats therefore I can not do the above. It would be helpful is Excel did not limit the number of conditional formats one can impose on a cell. Thanks! ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel: Having more than 3 conditional formats would be helpful.
There are a couple of options here... Check out these links...
http://www.mcgimpsey.com/excel/conditional6.html http://www.xldynamic.com/source/xld.....Download.html -- HTH... Jim Thomlinson "Lee Ellen" wrote: In Excel, I have a series of formulas that outputs one of six results.... let's say 1, 2, 3, 4, 5, and 6 (for simplicity). I would like to assign a color to each of the results of the formulas. So 1 would be blue, 2 would be green, etc. Excel limits me to 3 conditional formats therefore I can not do the above. It would be helpful is Excel did not limit the number of conditional formats one can impose on a cell. Thanks! ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How do I keep graph "data table" formats in separate excel workboo | Charts and Charting in Excel | |||
Conditional formats don't print | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Conditional Formats in Excel | Excel Worksheet Functions |