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

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

After using Excel for ten years, you would think that I should have known
about conditional formatting, but I never had to use so didn't bother to
learn about it.
Thanks for your quick answer my question.
Klaus Iden

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