To copy the contents and the formatting, choose All merging conditional formats. To combine your copied formats with existing conditional formats in the paste area, click the Merge Conditional ...

Fortunately, Excel 2007 enables you to select all pages and copy formatting to all of them. This method allows you save precious time and ensure formatting is consistent across all sheets.

Applying the same formatting to each sheet in an Excel workbook is ideal when each of your sheets is set up the same, but it can be helpful in other circumstances as well.