sorting information on a template.

[Wendy]

I have a chart that alternates colors for every row. How can I save the
template for this worksheet so that the colors don't leave their rows when I
sort the data?

 

[Debra Dalgleish]

Instead of colouring the rows, you can use conditional formatting. Chip
Pearson has instructions:

http://www.cpearson.com/excel/banding.htm