Excel 2007 Conditional Formatting

[jh1234]

Hi, I'm copying a sheet with lots of conditional formatting rules (5 rules per cell (not the same 5 for each), 32 rows by 20 columns) to a new workbook. The rules all copy but the order in which they are applied is changed. ?? This is frustrating! Thanks.

 

[jh1234]

*bump*

 

[number kruncher]

Rather than copying the cells to a new workbook, you could copy the whole worksheet to the new workbook.

 

[jh1234]

That's what I am doing ... sorry, I wasn't clear.

 

[number kruncher]

With the amount of Conditional Formatting in the worksheet, there is no quick answer.

However, if this is just a one off you could you copy the source workbook, to create the new workbook and remove any worksheets which you don't need.

If this is going to be a regular task, I'd look at making a macro to automate it.

 

[jh1234]

Ok, will do, thanks for your help.