View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Dave is offline
external usenet poster
 
Posts: 1,388
Default Conditional formatting of entire workbook

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.