Apply different color themes to worksheets withing a workbook

[kdarrow]

Hello,

Is there a way to apply different color themes on each worksheet? When I
apply one to my current worksheet, Excel applies it to all the worksheets
within that workbook!

Thanks!

 

[durango-cohen]

Hello,

Is there a way to apply different color themes on each worksheet? When I
apply one to my current worksheet, Excel applies it to all the worksheets
within that workbook!

Thanks!

Did you ever figure this out? I have the same question.
Thanks.

 

[GS]

Did you ever figure this out? I have the same question.
Thanks.

If you click on the intersecting corner of the rows/cols headings it
selects the entire sheet. Apply whatever color to the cells, then
select a new active cell.

If you use 'Styles' then you need to set/define a style for each sheet.

If you mean use a different color for each sheet's tab then right-click
the tab and you'll find what you need on the popup menu.

HTH

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion