Sort by color: Is there an easy way to sort columns or rows in EX
Is there an easy way to sort columns or rows in EXCEL by the color of the
text? |
Sort by color: Is there an easy way to sort columns or rows in EX
Take a look at this page on Chip Pearson's site:
http://www.cpearson.com/excel/SortByColor.htm It shows you how to do it, and there is an example sheet you can download with all the functions in. Hope this helps. Pete On Aug 15, 5:02*pm, MGP wrote: *Is there an easy way to sort columns or rows in EXCEL by the color of the text? |
Sort by color: Is there an easy way to sort columns or rows in EX
Take a look at this page on Chip Pearson's site:
http://www.cpearson.com/excel/SortByColor.htm It shows you how to do it, and there is an example sheet you can download with all the functions in. Hope this helps. Pete "MGP" wrote in message ... Is there an easy way to sort columns or rows in EXCEL by the color of the text? |
Sort by color: Is there an easy way to sort columns or rows in EX
See http://xldynamic.com/source/xld.Colo...r.html£sorting
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "MGP" wrote in message ... Is there an easy way to sort columns or rows in EXCEL by the color of the text? |
Sort by color: Is there an easy way to sort columns or rows in EX
How did the columns and rows get to be colored?
If by Conditional Formatting maybe you can sort on the values that created the colors? If manually see Chip Pearson's site for code. http://www.cpearson.com/excel/SortByColor.htm CF-colored cells do not respond to the colorindex property so you need something else. http://www.cpearson.com/excel/CFColors.htm Gord Dibben MS Excel MVP On Fri, 15 Aug 2008 09:02:04 -0700, MGP wrote: Is there an easy way to sort columns or rows in EXCEL by the color of the text? |
Sort by color: Is there an easy way to sort columns or rows in EX
That should have been
http://xldynamic.com/source/xld.Colo...r.html#sorting, the # got messed up -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Bob Phillips" wrote in message ... See http://xldynamic.com/source/xld.Colo...r.html£sorting -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "MGP" wrote in message ... Is there an easy way to sort columns or rows in EXCEL by the color of the text? |
All times are GMT +1. The time now is 07:36 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com