Gary

When you say you tried to open it do you mean you just double-clicked on it
after unzipping?

Best to just place it in your Office\Library folder then open Excel and go to
ToolsAdd-ins and check CFPlus.

Then you may have further problems when xld Tools appears on your worksheeet
menu bar.

When you select "Launch CFPlus" you see message

"Error while preparing the workbook."

This is how we resolved another person's problem with CFPlus.

First of all, go to ToolsOptionsSecurityMacro SecurityAdvancedTrusted
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 Dibben MS Excel MVP

On 29 Sep 2006 17:11:13 -0700, "Pete_UK" wrote:

Sorry, Gary, I can't help with this, and as Bob hasn't posted anything
for a couple of days I think he may have gone on holiday. I am sure he
would be grateful if you could contact him (via the xldynamic site) to
explain the problem you are having, and he'll get round to answering
you when he returns.

Pete

Gary wrote:
Thanks Pete,

I downloaded it but when i try to open the file. It says

Runtime error 9
Subscript Out Of Range.

Please Help.

"Pete_UK" wrote in message
ups.com...
You could download this free Add-in from Bob Phillips - it gives you up
to 30 conditional formats:

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

Hope this helps.

Pete

Gary wrote:
Hi,

I have 7000 rows, 5 columns.

I need to highlight the entire row if the value in column 5 is X

conditional formatting is limited to 3. I may have more than 10
criterion.
i.e. X, Y, Z, A, B, C, D, E, F, G, etc etc


Please help.
Thanks