Can the same conditional formatting rules be applied to multiple sheets in a workbook?

Question

Can anyone tell me if there is an easy way to copy the conditional formatting rules from one sheet in a workbook to another sheet in the same workbook?  

I use Office for Mac 2001.

Thank you so much.

Answer 1

Copying a cell will copy the coinditional formatting. you can apply it to more than 1 worksheet at a time, by selecting multiple sheet tabs (command click) and then set up the conditiional formatting. It will be applied to all selected sheets.

Answer 2

Selecting multiple sheets grays out the conditional formatting option (Excel 2013). Copying the cell to additional sheets does work, though.