When I start my sheet off every year it begins with a rule:
=$K1="✓" Applies to: =$A:$O
As I enter information down that range between A and O, I post headings which split up the data.
Every time I post these headings, it breaks the CF up into separate rules. Having all of these CF's is slowing down my worksheet, which I confirmed by deleting all the CF's and giving it a go.
Is there anyway I can stop it from doing this?
Thanks for any help
=$K1="✓" Applies to: =$A:$O
As I enter information down that range between A and O, I post headings which split up the data.
Every time I post these headings, it breaks the CF up into separate rules. Having all of these CF's is slowing down my worksheet, which I confirmed by deleting all the CF's and giving it a go.
Is there anyway I can stop it from doing this?
Thanks for any help