Conditional Formatting on Multiple Worksheets

[Claire U]

I want to apply conditional formatting to the same cell on 12 worksheets
within one workbook in Excel 2007. As soon as I select multiple worksheets,
the conditional formatting option is greyed out. The workbook is not shared
or protected and I used to be able to do this in Excel 2003.

Please help!

 

[Shane Devenshire]

Hi,

That is how it seems to work in 2007, this could be intentional or it could
be a bug, I will file it as a bug report.

Your solution:
Format the first cell or range on one sheet.
Click the Format Painter
Click the tab for the first sheet you want formatted the same way, either
Shift click on the last tab you want formatted or Ctrl click each of the
sheets you want. The click the equivalent position on one of the sheets.