Can I sort in Excel and leave the formatting (color) in place?

[Guest]

I have colored lines every other row and when I sort the colors go with the
text. How do I lock the formatting?

 

[Dave Peterson]

Maybe you could use format|conditional formatting to do the shading.

Chip Pearson shares a technique:
http://cpearson.com/excel/banding.htm