Moving cell contents to new cell loses background color in old cel

[John]

The background color I've chosen for all my cells (green) won't stay put.
When I move a cell and its text contents to an empty green cell adjacent to
it, the green color in the old cell turns white (or no color). This is
driving me nuts. Suggestions?

 

[Sheeloo]

How are you moving the cell? If you are cutting and then pasting in another
cell then source cell will lose the formatting...

You can copy and paste to the new cell and then delete the contents from the
source cell.

Are you using conditional formatting?

 

[John]

To move the cell contents, i'm mostly dragging from cell to another... that's
when I lose the original cell formatting/color. I'm not using condutional
formatting (dont know how!) Thanks.

 

[Sheeloo]

Dragging is like Cut and paste... If you want to retain the color in the
source cell then copy and paste and then delete the content of the source
cell.

 

[John]

Ok thanks for that!

Dragging is like Cut and paste... If you want to retain the color in the
source cell then copy and paste and then delete the content of the source
cell.