Conditional Formatting chaos in the rules manager when copy & pasting cells - WORKAROUND
The problem of the CF Rules Manager getting convoluted and very difficult to manage (as a result of copy and paste of cells) is well known and documented elsewhere. I have seen spreadsheets where a single Conditional Formatting rule has been duplicated for individual cells 100's of times. I have a partial workaround to prevent the Rules Table turning into a mess which is described in the attached file.
This is a blunt-force solution
Essentially apply your CF to large range - possibly $A:$XFD - which is every cell in your worksheet, then use formulae to identify which cells to apply the CF to. I showed 3 different approaches that use this method, they all work and, I think that it is probably about the only non-VBA way of using CF in a reliable way. Hope it's useful to someone out there.