Sorting problem
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 |
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 |
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 |
All times are GMT +1. The time now is 08:46 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com