Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sort rows by color | New Users to Excel | |||
How do I sort rows by color? | Excel Discussion (Misc queries) | |||
How do I sort my data by color? (color applied to rows) | Excel Worksheet Functions | |||
Sort columns by color | Excel Discussion (Misc queries) | |||
Excel sort by Fill Color by custom list sort | Excel Discussion (Misc queries) |