I am trying to set up a patterened spreadsheet, similar to a checkbook
register with alternating colors for each row. However, if I want to copy
and paste, or drag any information around, all the colors move from where it
was selected from. Is there a way to lock the formatting (keep the patterns
like as a background) but still be able to copy/paste and move things around?

Thanks!