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

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

krolfe wrote:

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