I've noticed that when I copy and paste some cell ranges, that sometimes the conditions get pasted out of order, essentially changing the formatting scheme. Every time I paste this range of cells, I have to open the conditional formatting dialog and move the top format back to the bottom.
I would love to know why this is happening, and how to fix it.