How do I keep fill color constant when cut & copying text?

[bwcland]

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!

 

[FSt1]

hi
this is call banding and using conditional formating.
See this site....
http://www.cpearson.com/excel/banding.htm

Regards
FSt1

 

[Earl Kiosterud]

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.

 

[motorcycleryder]

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!

Did you ever find out how to do this? I am having the same issue. Let
me know if you found a resolution.

Thanks,
Ben

 

[Gord Dibben]

Use Conditional Formatting to color the rows.

Clear the color formatting from the current rows.

Then select a great whack of rows the Format>CF>Formula is:

=MOD(SUBTOTAL(3,$A1:$A$2),2)=0

Pick a yellow color from from Format>Patterns.

The banding will hold throughout copy/paste and sorting and filtering.


Gord Dibben MS Excel MVP