Order of conditional formatting scrambled whenever I copy a spreadsheet.

I spent a massive amount of time creating spreadsheets to calculate the daily production of oil wells. I used a lot of conditional formatting, some rules have "stop if true" checked. In order for the conditional formatting to work properly certain rules (the ones with "stop if true" checked) HAVE to be at the top of the list.

Whenever I copy the original spreadsheet I made and make a new tab at the bottom for another month it completely scrambles the order of my conditional formatting. This means I'd have to go through dozens of spreadsheets and manually re-sort all of the rules I created.

How do I get Excel to preserve the proper order of all the conditional formatting rules I made when I create copies of a spreadsheet?

I am using Excel 2007 by the way. I attached a copy of one of the sheets I made as well.

Carter - DGS.xlsx

Hello jaherlihy,

How are you copying the worksheet? Try right clicking on the tab MARCH 2012 CARTER #1 and selecting the Move or Copy option. From the pop up window select the Move to End option and then check the box next to Create a copy.

This should preserve your conditional formatting.

Hey, thank you for the quick reply. That is the exact same way I am copying it.

I found something in a search that said this issue I am having is an excel 2007 bug.

It looks like you are using Excel 2010... So when you copied it everything stayed in order?

If this is the case I am going to be upgrading to Excel 2010 in the very near future.