Instead of Paste, use Paste Special - Values. That will leave the formatting (color) as it
was in the cell into which you're pasting.
Be careful cut/pasting stuff if there are formulas in the worksheet referring to these
cells. In some situations, it can cause the formulas to change.
--
Regards from Virginia Beach,
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"bwcland" wrote in message
...
This is for a basic Excell spreadsheet with columns and rows. I've used
white & yellow as the row fill colors for clarity when viewing the
spreadsheet.
When the information in a yellow cell is cut (or copied) and then pasted
into a white cell, the fill color turns yellow from the previous location.
Is there a way to keep the fill colors constant for each row, and only allow
the text to change when relocating to another cell?
Thanks!