Hi there,

Is there a way to permanently format a column of cells with a color?

I want an entire column to be the color green but when i move the values from this column, i want the color to stay in the column and not move with the values i'm moving, when i move the values to a new column, i want the values to adapt to the color of the cells in the new column (i.e. this column is yellow).

Is this possible?

Thanks