LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default Apply Conditional Format to all sheets in same workbook

Is there a way to apply a conditional rule to all of the worksheets in a
workbook? In other words, the cell range and format is the same for each
sheet but I'd prefer not to create the rule for 40 pages.

Thank you in advance.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Split a cell diagonally and apply a different conditional format. Champ Excel Worksheet Functions 2 February 5th 09 06:38 PM
apply conditional format to time TD[_2_] Excel Worksheet Functions 2 May 27th 08 11:44 PM
how to apply the same header or footer to all sheets in workbook Luenda Burke Excel Worksheet Functions 1 November 1st 06 05:45 PM
How to apply a format to an entire workbook mdeanda Excel Worksheet Functions 0 May 17th 05 06:17 PM
How to apply a format to an entire workbook Peo Sjoblom Excel Worksheet Functions 0 May 17th 05 06:11 PM


All times are GMT +1. The time now is 03:36 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"