You can use Conditional Formatting to do this. See
www.cpearson.com/excel/banding.htm
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"Excel User" wrote in
message
...
Greetings and Thanks in Advance!
I have a list which I have formatted using AutoFormat List 1,
but when I
sort some of the shaded rows are next to one another instead of
alternately.
How can I make the alternate shading stay after sorting? Thanks
again.