coditional formatting needs a "consolidate" and "group" option.
I typically apply a conditional format to an entire column. Sometimes while sorting or copy/pasting, it gets all jacked up and makes multiple copies of the same formatting but only applied to some cells in the column. Every once in a while I have to go and manually fix this by making one apply to the entire column and deleting the rest. This can take a lot of time and be very frustrating especially if there is multiple format conditions. In some cases of 10+ formatting conditions, after a few copies or sorts, I'll have hundreds of fragmented formats to sift through. Also, the ability to group a set of formats together, so they can be applied to a range together and copied together to another sheet.