Conditional Formatting Multiple Sheets

[screach]

Ok, so I remember in the old days of excel being able to apply formatting accross multiple sheets by simply selecting all sheets and then applying conditional formatting. I understand this is not the case any longer.

So...if I am doing a conditional format based upon a statement such as

=$B1="ACTIVE"

How do I apply this to other sheets without copying and pasting it into each individual sheets conditional formatting. I have 30 sheets in a workbook I need to apply this to but there are 4 sheets in those workboooks I do not want to apply the formatting to. Can I use a formula to choose what sheets to apply it to and/or what sheets not to apply it to?

 

[Chihiro]

See link. I'd go with recording Macro solution (if you are familiar with coding, you can loop through worksheets to apply).

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

 

[screach]

Thanks Chihiro, I had looked at that option but was hoping for a formula based solution. I also know I can code a solution using VB too, but was looking for an easy out hehe.

Thanks!