G Guest Jan 12, 2006 #1 I have colored lines every other row and when I sort the colors go with the text. How do I lock the formatting?
I have colored lines every other row and when I sort the colors go with the text. How do I lock the formatting?
D Dave Peterson Jan 12, 2006 #2 Maybe you could use format|conditional formatting to do the shading. Chip Pearson shares a technique: http://cpearson.com/excel/banding.htm
Maybe you could use format|conditional formatting to do the shading. Chip Pearson shares a technique: http://cpearson.com/excel/banding.htm
