What's the criteria for all your scenarios? I mean, chances are, using a
=if() with an or() or and and() will do just fine, 1 condition.


Danny


On Mon, 11 Jul 2005 05:21:03 -0700, Jimbo
wrote:

There are a possible 5 different conditions which I wish to use to
determine
the colour of a given cell. Each condition should result in a different
colour.
Using the "wizard" I get a maximum of 3 colours.
Is there a slick way around this limitation?



--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/

How can I conditionally format in excel for >3 conditions
 

There are a possible 5 different conditions which I wish to use to determine
the colour of a given cell. Each condition should result in a different
colour.
Using the "wizard" I get a maximum of 3 colours.
Is there a slick way around this limitation?

Try this, Jim:
http://www.vbaexpress.com/kb/getarticle.php?kb_id=90

*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Jimbo" wrote in message
...
There are a possible 5 different conditions which I wish to use to
determine
the colour of a given cell. Each condition should result in a different
colour.
Using the "wizard" I get a maximum of 3 colours.
Is there a slick way around this limitation?

This link should help:

http://www.xldynamic.com/source/xld.....Download.html

--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"Jimbo" wrote in message
...
There are a possible 5 different conditions which I wish to use to determine
the colour of a given cell. Each condition should result in a different
colour.
Using the "wizard" I get a maximum of 3 colours.
Is there a slick way around this limitation?

How about checking out your system Time & Date?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Danny" wrote in message
...

What's the criteria for all your scenarios? I mean, chances are, using a
=if() with an or() or and and() will do just fine, 1 condition.


Danny


On Mon, 11 Jul 2005 05:21:03 -0700, Jimbo
wrote:

There are a possible 5 different conditions which I wish to use to
determine
the colour of a given cell. Each condition should result in a different
colour.
Using the "wizard" I get a maximum of 3 colours.
Is there a slick way around this limitation?



--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/