Apply different color themes to worksheets withing a workbook

  • Thread starter Thread starter kdarrow
  • Start date Start date
K

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!
 
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!
Click to expand...

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

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
 
Back
Top