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

Regards
FSt1

"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!