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:

Thanks

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.....Download.html

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

"eric beck" <eric wrote in message ...
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:

Thanks