MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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
new color.

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


Posted by Ivan F Moala on June 16, 2001 10:15 PM

No need for VBA unless you want this.
Goto Tools / Options / Colour
Select the colour that you want to change here
Can also reset fromm here.

Via code it eould be something like;

ActiveWorkbook.Colors(35) = RGB(252, 237, 208)

Lookup help on Colors & RGB

HTH

Ivan