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