When selecting the first worksheet and holding down the shift key and selecting the last worksheet in the unprotected workbook, the conditional format is not available. Version is Excel 2007, is there another process for copying the conditional formatting to all worksheets in the workbook?