Conditional formatting of entire workbook

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

computhom - 16 May 2008 19:24 GMT

I have a workbook that has separate sheets for each day of the school year
and wanted to see if I can conditionally format the whole workbook at once
instead of having to do one page then copy. Right now I have one that is
live data and I am creating another version for next year as a template.

Reply to this Message

Dave - 16 May 2008 22:02 GMT

Hi,
You can select all the sheets at once.
Click on the first sheet tab, then hold down Shift while you click on the
last sheet tab.
Now anything you do on the active sheet will be done to all sheets,
including Conditional Formatting. To deselect all sheets, click any one tab.
Regards - Dave.

Reply to this Message

computhom - 19 May 2008 19:07 GMT

I have tried that but when I do, the conditional formatting is greyed out and
I cannot select it. Is there a limit to the amount of pages? I have almost
200 pages I am trying to do here.

> Hi,
> You can select all the sheets at once.
[quoted text clipped - 3 lines]
> including Conditional Formatting. To deselect all sheets, click any one tab.
> Regards - Dave.

Reply to this Message

Dave - 20 May 2008 03:00 GMT

Hi,
I'm not aware of any limitation on the number of sheets that can be grouped
for conditional formatting.
Check to make sure that the workbook isn't protected, or that no individual
sheets are protected.
Regards - Dave.

Reply to this Message