I'm trying to set up conditional formatting for a range in my VBA code, but
I'm not having any luck. Is conditional format setup only available from the
user interface menu? I see that there's a ConditionalFormats collection as
well as a ConditionalFormat object that I can create and add to a collection,
but how do I define the formula for the conditional format? If I do it on the
UI menu, I would use "Formula Is" and some formula. However, I'd like to do
this in my VBA code. Any ideas? Thanks in advance.
--
Bruce J. Baumann