Thread: Apply Conditional Format to all sheets in same workbook
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
  
Posts: 5,939
Default Apply Conditional Format to all sheets in same workbook
A CF is a format like any other format. Create one page and then copy and
paste to the rest of the pages...
--
HTH...

Jim Thomlinson


"Der Musensohn" wrote:

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.
Reply With QuoteReply With Quote