I understand that the OP wants the formatting of the original position of a value to remain while the value is dragged to another location.
In my experiments, no matter how I use conditional formatting to format columns with a colour, dragging value from one column to another removes the conditional formatting for the cells concerned in both columns.
I used =COLUMN()=1 =COLUMN()=2 etc
and this one that drags the formatting with the value leaving the original cell with no background.
=mod(column(),1)=0 =mod(column(),2)=0 etc
If I'm doing something wrong, I'd sure like to know.
Bookmarks