Additional Conditions for Conditional Formatting

[Guest]

I know that Excel 2000 will only allow you to have 3 Conditions for
Conditional Formatting, is there any way to get more?

Not sure how many more will be needed but 3 isn't enough...

could you notify me to this address: (e-mail address removed)

Thanks

 

[David McRitchie]

Hi Eric,
One way is to use a Change Event macro (not for formulas)
http://www.mvps.org/dmcritchie/excel/event.htm#case

The other way is t use an Addon that extends the number of conditions
Extended Conditional Formatter «Excel addin«, Bob Phillips
& Frank Kabel, addin that makes it possible to enter up to 50 conditions
with the same entry type panels as builtin Conditional Formatting.
Note this is Beta software (testing not production). (posted 2004-11-07)
http://www.xldynamic.com/source/xld.CFPlus.Download.html