hi
see if this site helps you out.

http://www.cpearson.com/Excel/banding.aspx

Regards
FSt1

"ybeckett" wrote:

I want to set up a list that has alternating coloured rows to make it more
legible but I want the coloured rows to remain static while the data is
sorted in various ways. Is it possible to do this? I have used the list
template in excel but the gray row colour is less than ideal. I want to use a
pale yellow and a pale green alternating.