Conditional Format Problem

[stephen.smith]

Hi Guys
Can anyone tell me if its possible to perform conditional formatting on numerous worksheets at one time. I have about 50 worksheets that I would like to perform the same conditional format on. Is there a way to do this.
Thanks in advance for any help
Stephen

 

[Andrew Poulsom]

Did you try it in Group mode?

http://office.microsoft.com/en-us/excel-help/select-one-or-multiple-worksheets-HP005202492.aspx

 

[stephen.smith]

yes this doesnt work, it wont allow any conditional formatting when in group mode.

 

[Andrew Poulsom]

It worked for me in Excel 2003. What version are you using?

 

[cummingsea]

It worked for me in Excel 2003. What version are you using?

When I used Excel 2007 and 2010 for Windows and now I use Excel 2011 for Mac I never could make multiple page CF work. It just would not let you.

 

[Andrew Poulsom]

Yup, it's gone!

http://excel.tips.net/T003433_Applying_Conditional_Formatting_to_Multiple_Worksheets.html