M MGP Aug 15, 2008 #1 Is there an easy way to sort columns or rows in EXCEL by the color of the text?
P Pete_UK Aug 15, 2008 #2 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
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
P Pete_UK Aug 15, 2008 #3 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
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
B Bob Phillips Aug 15, 2008 #4 See http://xldynamic.com/source/xld.ColourCounter.html£sorting -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy)
See http://xldynamic.com/source/xld.ColourCounter.html£sorting -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy)
G Gord Dibben Aug 15, 2008 #5 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
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
B Bob Phillips Aug 16, 2008 #6 That should have been http://xldynamic.com/source/xld.ColourCounter.html#sorting, the # got messed up -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy)
That should have been http://xldynamic.com/source/xld.ColourCounter.html#sorting, the # got messed up -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy)
