Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing Cell Background Color based on data from another cell | Excel Discussion (Misc queries) | |||
cell background color and cell text color | Excel Worksheet Functions | |||
set the background color of the current cell(active cell) | New Users to Excel | |||
Default Border, Font Color, and Cell Background Color | Excel Discussion (Misc queries) | |||
moving the contents of a cell | Excel Worksheet Functions |