order of conditional formatting rules

[ACLrecon]

I have a sheet that has some cells with multiple conditional
formatting rules. These rules are arranged in some order, so that it
stops executing the conditional formats once a certain condition has
been met.

My problem is that when I make a copy of this sheet, the order of
conditional formatting rules is not maintained on the copy. Why is
this? Does anyone know how to fix it, short of manually (and
tediously) rearranging the order of rules on the copy?

Thanks in advance.

 

[Bob Phillips]

Is this Excel 2007 or earlier?

 

[ACLrecon]

It's Excel 2007.