Thanks. I know that works but I'm just wondering if there's a way to
drag-and-drop without screwing up the colors.

Hi

Try using CopyPaste Special
You then have the choice of pasting Values or Formulae, and the format
of the receiving cell(s) will not be altered.