Conditional formatting when copying a worksheet; order of conditions changes

I have a worksheet (monthly financial forecast) with a lot of conditional formatting in it. I would like to copy this worksheet 12 times (right click on worksheet and choose "Move or Copy"), but when doing so, the order of conditions for formatting changes in the copied worksheet. E.g. when a condition is listed as last condition in the original worksheet, in the copied worksheet it is moved all the way to the top of the list with conditions for formatting. This results in the conditioning formatting not working the way I want it to work. I can change the order of conditions manually (and move the condition to the bottom again), but that is a lot of work (about 30 cells times 12 worksheets). There must be an easier way.

Any suggestions?

I'm using Excel 2010.

Thank you for your help.

Originally Posted by Richard Buttrey

Hello,

Would you share the workbook with us. I can't replicate that effect.

I think I found a solution: selecting the relevant sheet en while pressing the Ctrl key, left clicking on the sheet and dragging it to the desired place makes a perfect copy, including the right conditional formatting conditions. Thanks for your help though.