Check out the page for a Conditional Formatting example that should help:
http://www.cpearson.com/excel/banding.htm

tj

"Klaus" wrote:

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