cell shading

S

Shooter

My worksheet is large and has many areas with cells shaded a dark grey
color(cell pattern color). I would like to highlight a large section of the
worksheet and set a new lighter shade color without affecting the existing
shaded cells. Is this possible? Thanks for your help.
 
M

Myrna Larson

Are you implying that these dark grey cells are included within the large
section you are talking about? If so, if you select that large section and
change the color, it will affect the cells that are now dark grey, i.e. ALL
selected cells.
 
R

Richard Buttrey

My worksheet is large and has many areas with cells shaded a dark grey
color(cell pattern color). I would like to highlight a large section of the
worksheet and set a new lighter shade color without affecting the existing
shaded cells. Is this possible? Thanks for your help.
Click to expand...

Probably the only way is a VBA macro which examines all the cells in
turn and only changes the colour if it's not grey.

If you're comfortable working with arranging a VBA macro, come back
and I'll suggest some code to do it.

Rgds

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________
 
Top