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

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?

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

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" wrote:

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?

Moving cell contents to new cell loses background color in old
 

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" wrote:

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" wrote:

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?

Moving cell contents to new cell loses background color in old
 

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" wrote:

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" wrote:

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" wrote:

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?

Moving cell contents to new cell loses background color in old
 

Ok thanks for that!

"Sheeloo" wrote:

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" wrote:

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" wrote:

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" wrote:

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?