I have a spread sheet with different colored columns. I often drag
and drop data from one column to another but the color in the cells
gets dragged along leaving the cells white with no fill. Can this be
avoided. I've tried conditionally formatting the column colors but it
doesn't fix this. Thanks.