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

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

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