Hi
for color banding better to use conditional formatting:
http://www.cpearson.com/excel/banding.htm

--
Regards
Frank Kabel
Frankfurt, Germany

"Klaus" schrieb im Newsbeitrag
...
Is there anyway to sort a series of rows and not disturb the cell
formatting.
My rows are alternate colours and during sorting this formatting
moves with
the values thereby messing up the appearance of the worksheet.
Klaus Iden