conditional formatting - order of rules
 

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 doesnt work in the way I need it to.

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

Many thanks,
Andy