Applying Conditional Formatting to Multiple Worksheets - Excel 200
 

How do you simultaneously apply conditional formatting to multiple worksheets
in Excel 2007?

In 2003, you could select mutliple worksheet tabs, apply conditional
formatting to one worksheet, and it would populate to the other worksheets
simultaneously. This function is not available in Excel 2007. How can this
be done in Excel 2007?

Thanks.