A
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.
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.