Use Conditional Formatting to color the rows.

Clear the color formatting from the current rows.

Then select a great whack of rows the FormatCFFormula is:

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

Pick a yellow color from from FormatPatterns.

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


Gord Dibben MS Excel MVP


On Sun, 20 Apr 2008 20:28:36 -0700 (PDT), wrote:

On Apr 19, 9:42*am, bwcland wrote:
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