conditional formatting - order of rules

[Andy the yeti]

Hi,

I am using conditional formatting in Excel office 2007. I have 5 rules that
are applied in the order I have created them. My problem is that whenever I
create a copy of the worksheet and put it into another workbook the order
changes and the conditional formatting doesn’t work in the way I need it to.

Any idea why it’s changing the order of the rules and how I can overcome the
problem please?

Many thanks,
Andy