Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Conditional formatting capability for 20+ conditions not just 3.
I have a spreadsheet that I use to schedule workers. This spreadsheet is
setup with conditional formatting for 3 of the positions. However, I have to manually go thru and change the formatting for the others which at times can be over 20 positions. To be able to assign conditional formatting for all possiblilties in the same cell would be great. Example cell contains schedule tasks indicated by letter codes. "I" would display Green background "R" would display Light Blue background "V" would display Medium Blue background "N" would display Yellow background "ST" would display Tan background "SLR" would display Light Orange background "BP" would display Dark Blue background etc... ---------------- 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...lic.excel.misc |
#3
|
|||
|
|||
Conditional formatting capability for 20+ conditions not just
David,
Thank you for the suggestions. I have downloaded the addin and will try it soon. Thanks again, Charles Smittenaar "David McRitchie" wrote: Hi Charles, You could possibly use a Change Event macro http://www.mvps.org/dmcritchie/excel/event.htm#case or you could install an addin that works the same as condition formatting without the limit of three "wishes". take a look at CFPlus - Extended Conditional Formatter, Bob Phillips http://www.xldynamic.com/source/xld.....Download.html --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Charles Smittenaar" <Charles wrote in message ... I have a spreadsheet that I use to schedule workers. This spreadsheet is setup with conditional formatting for 3 of the positions. However, I have to manually go thru and change the formatting for the others which at times can be over 20 positions. To be able to assign conditional formatting for all possiblilties in the same cell would be great. Example cell contains schedule tasks indicated by letter codes. "I" would display Green background "R" would display Light Blue background "V" would display Medium Blue background "N" would display Yellow background "ST" would display Tan background "SLR" would display Light Orange background "BP" would display Dark Blue background etc... ---------------- 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...lic.excel.misc |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
More than 3 Conditional Formatting Conditions | Excel Worksheet Functions | |||
Conditional formatting wth more than 3 conditions | Excel Worksheet Functions | |||
Additional Conditions for Conditional Formatting | Excel Worksheet Functions | |||
Conditional formatting: I have five conditions, how to do this? | Excel Discussion (Misc queries) | |||
Adding more than three Conditions to 'Conditional Formatting' | Excel Discussion (Misc queries) |