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!

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!

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!