View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo Sheeloo is offline
external usenet poster
 
Posts: 793
Default 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?