In , Paul Hyett
spake thusly:

In microsoft.public.excel.misc on Tue, 21 Aug 2007, Dallman Ross
wrote :

I coincidentally just finished working out a reusable module to
handle some Conditional Formatting functions. It's working out
to be rather nifty for me, so I've made a web page about it and
am happy to give away the code.

http://heliotropos.com/xl/code/cfmagic.html

Looks impressive - I just wish I could understand it. :)

Well, if I can explain anything, let me know.

Basically, it's for if you're coding page formats in VBA directly
and not via the CF dialog pulldown from the Excel Format menu.
The CF code is long and messy, and if you have a sheet that uses
a lot of it you will fill up your modules with gobbledygook
pretty fast. I didn't like that, so went about creating a
reusable submodule you call from your main code. You just feed
it the CF formulas, the (bottom) border color, and the fill
colors you'll want.

The formulas I show in the sample, you could work through by
simply typing (or copying and pasting) them into the CF dialog
region directly to see what they do (on a sample worksheet,
of course).

=dman=