Here's one way:

http://www.andrewsexceltips.com/menu..._colour_even_r
ows.htm

HTH
Jason
Atlanta, GA

-----Original Message-----
Is there a way to autoformat a spreadsheet ot shade
every other row? If so,
I think it would be great if it would stay formatted
that way after a sort.

thx
.