conditional formatting duplicates on sort, very slow to clean up
I have sheet with multiple of conditional formatting rules on entire column
(to highlight data entry errors).
PROBLEM #1 on sorting - sometimes the rules are duplicated (many times). e.g. as well as original 9 rules now i have about 900 for specific cells.
PROBLEM #2 deleting these additional rules is VERY slow - have to do it one at a time, and each one takes about 5-10 seconds.