Changing color of many cells and borders at once

  • Thread starter Thread starter Scott
  • Start date Start date
S

Scott

Hello, could someone please help with this

I have one basic template I use, this template has a number of clones
for each of our individual customers with there own comapny colors for
the font and borders. Problem is the base template s always being
improoved, so after a number of changes are done the ss must then be
reporduced for each customer by changing each cell, border, lines etc to
their own company color. I would like to produce some code or procedure
to do this quickly or do once and then just rerun the code each time.

I was thinking the way to do it would be to create the code that will
select all the cells that need changing, ask for input of the new color
(ie "red" or the color code) then have it go ahead and do it, but how do
I selcet different border lines etc??

Or better is there a way to just change each instance of a color
(whether its font, border lines etc) from say blue to red in one full
swoop ?????

any help is greatly appreciated.

TIA
 
You may want to start investigating Styles (Format|Style...).

You can create multiple styles with different formatting options. Then make
sure all your green double bordered cells are using the "UglyStyle3".

Then when you want to change all these cells, you can just change that style--to
"PrettyStyle1" <vbg>.
 
Back
Top