How can I conditionally format in excel for >3 conditions

  • Thread starter Thread starter Danny
  • Start date Start date
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
 
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.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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2
conditional formatting in Excel 2007 1
Conditional Format 5
Excel 2007 - A Conditional Formatting ?'s 1
conditional formatting 1
Conditional Formatting and Formulas 1
Excel Conditional Formatting 1
More than just 3 Conditions for Conditional Formatting? 2

Back
Top