Excel Global Color Change Macro?
Posted by Questor on June 16, 2001 7:11 PM
I am working with a Excel '97 worksheet that contains
both formatted cells and conditional formatted cells
that display a single pre-selected color.
What I need is a macro to allow a new pallette color
selection that results in all cells with the
pre-selected color to automatically change to the
This would be considered a global color change that
also changes conditional formatted cells. Because
of the large number of cells and the need to
manually change each of the conditional formats, I
am seeking a faster way to simplify this task.
Question - can Excel perform this macro global color
change so it does not require VBA or MFA to call an
external procedure? Does anyone want to share code
that will perform this task or provide examples to
help get me started?
Thanks, in advance... Questor