How can I conditionally format in excel for >3 conditions

D

Danny

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
 
J

Jimbo

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?
 
R

RagDyeR

This link should help:

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

--

HTH,

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

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?
 
Top