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?

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?

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?

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?

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?