In , Gord Dibben
<gorddibbATshawDOTca spake thusly:

Three conditions, 4 if you count default, is the limit in 2003.

Go to Bob Phillips' site and download the CFPlus add-in which
allows up to 30 conditions.

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

This is a fabulous resource. Thank you for posting about it.
I have been wanting more than three conditional formatting
options since ... forever.

However, when I just installed it and tried to launch it in
an existing workbook, it gave me an error message: "Error
while preparing the workbook." :-(

Not sure what's up with that. This is Excel 2002 on XP Pro.

Dallman