Created attachment 70523 [details] Test document - one CF range splits apart after moving data Hi In attached document, there is conditional formatting applied to cells A1:B17. Steps to reproduce: 1. Select cells A9:B17 2. Cut them (Ctrl+X) 3. Place cursor in cell A8 4. Paste (Ctrl+V) 5. Go to Format → Conditional formatting → Manage... You will see that there are two conditional formatting ranges: A1:B7 and A8:B16. Since conditional formatting rules are the same in both cases, this could (and should) be just A1:B16. If user now decide to modify CF rule, he must modify it in two places instead of just one. Of course this is simplified case of this bug. On larger datasets a moment of moving data back and forth can create dozens ranges of the same CF rules. This problem exists since introduction of modified CF dialogs in 3.6.0 and I can still reproduce it in 3.6.4-rc1.
This will not be fixed. Copying conditional formats will create new conditional formats to prevent increasing the range in case they are not overlapping. This is important for conditional formats that are not only based on the current cell value but calculate based on the cond format range.