In , Gord Dibben
<gorddibbATshawDOTca spake thusly:
First of all, go to ToolsOptionsSecurityAdvancedTrusted
Publishers.
Check "trust all installed add-ins and templates" and "trust
access to visual basic project".
I was thinking you'd say that. :-) (I saw your other follow-up,
too, correcting the menu syntax.) That was not it, however.
That already was set properly. I run a number of add-ins,
so had that issue in the past.
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.
I never figured out what was wrong, and I did close and re-open
the worksheet a few times trying. But now it does work. Cool.
I have various complex hiden worksheets in that workbook already
myself, and I was asking myself if that could be the reason for
the error. (I have a macro to refresh downloaded data to a hidden
worksheet and then reproduce the cells I need in the visible worksheet,
along with other added formulas. This is sort of my home-built
method of trying for more robust data integrity, the other way
I'd consider being to use Access instead of Excel.) :-)
In addition to the 30 full conditional formats Bob is providing,
the original three (plus default) also still work, so that's
actually 33 or 34, depending on how we count. Thanks again,
Bob, and Gord for steering some of us over there!
Dallman
-----------------------
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