Conditional Formatting Precidence when copying to new sheet in 200
 

Within a worksheet I have two lots of conditional formatting which overlap
certain cells. Excel 2007 puts the first condition I seet as being second in
the precidence list and not first as I wanted, so I simply changed the
precidence to move it up. The formatting works fine.

When you copy the sheet to either a new workbook or sheet then the
precidence on this new sheet is changed back to the original position.

Any ideas?