ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Apply different color themes to worksheets withing a workbook (https://www.excelbanter.com/excel-discussion-misc-queries/246832-apply-different-color-themes-worksheets-withing-workbook.html)

kdarrow

Apply different color themes to worksheets withing a workbook
 
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!
--
kdarrow

[email protected]

Apply different color themes to worksheets withing a workbook
 
On Wednesday, October 28, 2009 1:38:07 PM UTC-5, kdarrow wrote:
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!
--
kdarrow


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

GS[_2_]

Apply different color themes to worksheets withing a workbook
 
On Wednesday, October 28, 2009 1:38:07 PM UTC-5, kdarrow wrote:
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!
--
kdarrow


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




All times are GMT +1. The time now is 07:33 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com