ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Sorting in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/63251-sorting-excel.html)

Ciaran McAneny

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.

Peo Sjoblom

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