![]() |
Sorting in Excel
Hi. I already think I know the answer may be no, but... Is there a way in
Excel 2003 to sort a column or range by cell / font colour? Cheers. |
Sorting in Excel
No, next version of Excel can do this, now you need to use a UDF to tag the
colorindex in a help column then select both columns and sort on that help column For colour functions see: http://www.cpearson.com/excel/colors.htm -- Regards, Peo Sjoblom "Ciaran McAneny" <Ciaran wrote in message ... Hi. I already think I know the answer may be no, but... Is there a way in Excel 2003 to sort a column or range by cell / font colour? Cheers. |
All times are GMT +1. The time now is 08:19 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com