Reduce / Eliminate Fragmentation of Conditional Formatting.
If I copy a cell that has Conditional Formatting and what to copy the CF to the destination then Excel records this as a new Instance of the Rule. If the cell has multiple Conditional Formats and is copied to many non-contiguous cells then very soon there is a mess in the Conditional Format windows.
If I then want to edit a rule I have multiple instances that I need to edit.
Suggestion - List the ranges of all cells associated with the rule in eth one place. this would Solve Both Problems