Conditional Formatting

  • Thread starter Thread starter Bob Phillips
  • Start date Start date
B

Bob Phillips

This posting is to give notice of a new, free add-in that addresses a
frequently requested function within Excel, that of having more than 3
conditional formats.

The add-in, which was conceived and developed by Frank Kabel and Bob
Phillips, is in Beta release, and can be obtained at
www.xldynamic.com/source/xld.CFPlus.Download.html. Currently, there is no
documentation, but you should find it relatively simple to use, with it's
own menu, and quick launch options. The only function that we draw your
attention to is something that we call 'special conditions'. When the
Condition form is shown, in Formula mode, there is a dropdown to the right,
which, if clicked shows a list of these special conditions. These provide
simple generation of formulae for a number of condition requirements, such
as row striping, date conditions, etc.

We are announcing this product through the NGs, as a means of soliciting
participation in the testing of this Beta release. As a Beta release, we
cannot rule out that there may be some problems and some errors with the
code. We would appreciate feedback on problems and errors, but please do not
use the NGs to report these problems, use the link at the foot of the page
mentioned above. Major problems will be fixed and released as quickly as
possible, whereas minor problems or significant enhancements may be delayed
until a production release. The production release will also include a help
file.

We hope that you find this add-in useful, and easy to use.

Frank Kabel & Bob Phillips
 
Bob

I'm sure this will be very popular !

It's early days yet so nothing to report ... but you didn't include the link
to contact you .

Regards

Trevor
 
Hi, *Bob Phillips*.

Thanks.
Does it work with Excel 2002/Office XP under WinMe?

Best regards

Patrick.
 
Hi Patrick,

It has been tested with

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Patrick,

Try again.

It has been tested with XL2002, but not with ME, as neither Frank nor I
have ME. I would be interested in your experiences, in order that we can
post a yes or no with that combo.

Regards

Bob

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Hi, Bob.

I tried to install this addin, but I got a message "erreur d'exécution 5" .
When selecting Help:
(Sorry but my English is not good enough to translate)
***********************************************************
Appel de procédure ou argument incorrect (erreur 5)

Une partie de l'appel n'a pas pu être effectuée. Causes et solutions de
cette erreur :

Un argument dépasse probablement la plage des valeurs permises. Par exemple,
la fonction Sin ne peut accepter que les valeurs comprises dans une certaine
plage. Les arguments positifs inférieurs à 2 147 483 648 sont acceptés,
tandis que 2 147 483 648 génère cette erreur.
Vérifiez les plages permises pour les arguments.

Cette erreur peut également se produire si vous tentez d'effectuer un appel
à une procédure qui n'est pas valide sur la plate-forme en cours. Par
exemple, certaines procédures ne sont valides que pour Microsoft Windows, ou
pour le Macintosh, etc.
Vérifiez les informations spécifiques de la plate-forme sur la procédure.

Pour plus d'informations, sélectionnez l'élément en question et appuyez sur
F1 (sous Windows) ou AIDE (sur Macintosh).
*****************************************************************

WinMe et Excel 2000/Office XP
CFPlus.ini et CFPlus.XLA are in C:\Program Files\Microsoft
Office\Office10\Macrolib\complémentaires téléchargées\30 MEFC

Regards.

Patrick
 
Patrick,

We have not yet released a help file (although we have built the hooks into
the add-in).

Does it work that aside?

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Bob ,

When I tell about Help, it is about the help of the mistake message "erreur
d'exécution 5" when opening Excel after add CFPlux.XLA in Outils, Macro
Complémentaires (Tools, Complementary macro(,) in english.

So I can't use this .XLA. Sorry.

Best regards.
 
Hi Patrick
maybe you could send me via private email a screenshot of this error so
Bob and I may be able to track this down. We may send you a version
with some more debug statements so we can more easily find the cause
for this error as both of us (as Bob said) have neither Windows Me nor
an French Excel version
private email: frank[dot]kabel[at]freenet[dot]de
 
aahhhhh ... only got as far as "use the link at the foot of the page".
Missed the "mentioned above". C'est la vie. Je suis desolé. :-(
 
Bob Phillips said:
This posting is to give notice of a new, free add-in that addresses a
frequently requested function within Excel, that of having more than 3
conditional formats.
Click to expand...
....

FWIW, McAfee Virus Scan suspends execution of the initialization code. Bob &
Frank, if your add-in triggers anti-virus software, you're not going to get
many business users to use it.

How am I supposed to use this? Installing the add-in under XL2K, there's no
new menu entry in either Format or Tools menus. Since you provide no docs,
you might want to add a sentence or two to the web page providing basic
instructions for accessing the wonderful functionality. FWIW, I got a
runtime error when installing it using Tools > Add-ins under XL2K,
specifically, Run-time error 5: Invalid procedure call or argument.

Y'all didn't violate one or another of the very basic rules of Excel
development, did ya? Either state any version dependencies (e.g., only works
with XL2002 or higher), or write & test in the oldest targetted Excel
version (XL97? XL2K? XL2002?).
 
Hi Harlan

Harlan said:
...

FWIW, McAfee Virus Scan suspends execution of the initialization
code. Bob & Frank, if your add-in triggers anti-virus software,
you're not going to get many business users to use it.
Click to expand...

Agreed and that's the reason why I asked for the virus scanner which
causes an error to see what the reason for this warning is

How am I supposed to use this? Installing the add-in under XL2K,
there's no new menu entry in either Format or Tools menus. Since you
provide no docs, you might want to add a sentence or two to the web
page providing basic instructions for accessing the wonderful
functionality. FWIW, I got a runtime error when installing it using
Tools > Add-ins under XL2K, specifically, Run-time error 5: Invalid
procedure call or argument.
Click to expand...

There's a new top-level menu (called 'XLD'). We started putting this
new functionality under the Format menu but Excel has a bug which
prevents some functionality in this case.
The error is interesting as it was tested under XL2K. We had the same
error report for Windows Me and are currently looking at this


Y'all didn't violate one or another of the very basic rules of Excel
development, did ya? Either state any version dependencies (e.g.,
only works with XL2002 or higher), or write & test in the oldest
targetted Excel version (XL97? XL2K? XL2002?).
Click to expand...

Bob just is in the progress to add the tested platforms. It should run
in all Excel versions starting with Excel 97 under any Windows
platform. It won't run under a MAC environment though

Frank
 
Back
Top