First of all, go to ToolsOptionsSecurityAdvancedTrusted Publishers.

Check "trust all installed add-ins and templates" and "trust access to visual
basic project".

OK out then click on Xld Tools and "Launch CFPlus"

You will get the error message. Click "Yes" to answer the question.

CFPlus should launch.


Gord

On Sun, 17 Sep 2006 16:25:52 +0000 (UTC), Dallman Ross <dman@localhost. wrote:

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