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
|
|||
|
|||
More than 3 outcomes (formats) with conditional formatting
I think I know the answer to this already (i.e., use
worksheet_change event instead of conditional formatting), but anyway, I'd like to have a groups of cells be colored up to 8 different ways based on 8 different conditions. Is there any way (other than the one mentioned above) to do this with conditional formatting? Thanks! |
#2
|
|||
|
|||
Hi
short answer: no :-) -- Regards Frank Kabel Frankfurt, Germany David Jenkins wrote: I think I know the answer to this already (i.e., use worksheet_change event instead of conditional formatting), but anyway, I'd like to have a groups of cells be colored up to 8 different ways based on 8 different conditions. Is there any way (other than the one mentioned above) to do this with conditional formatting? Thanks! |
#3
|
|||
|
|||
Hi David,
part one, yes (yes, you're correct, use an Event macro) part two, no (no, you can't use Conditional Formatting) For some help in using an Event Macro for when Condition Formating limit of 3 colors is insufficient see http://www.mvps.org/dmcritchie/excel/event.htm# --- 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 "Frank Kabel" wrote... short answer: no :-) David Jenkins wrote: I think I know the answer to this already (i.e., use worksheet_change event instead of conditional formatting), but anyway, I'd like to have a groups of cells be colored up to 8 different ways based on 8 different conditions. Is there any way (other than the one mentioned above) to do this with conditional formatting? Thanks! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Pivots and keeping conditional formatting | Jenn | General Discussion | 1 | August 11th, 2004 10:35 PM |
Copy Conditional Formatting | Bianca | Worksheet Functions | 2 | August 9th, 2004 01:47 PM |
Conditional Formatting Questions | Andy B | Worksheet Functions | 1 | May 12th, 2004 02:48 PM |
Conditional Formatting on a cell that has an IF function | DDM | Worksheet Functions | 0 | May 11th, 2004 05:13 PM |