Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Color code
I entered rows of data and color coded the text in the rows. How do I sort
the rows by color |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Color code
You need a macro: http://www.cpearson.com/excel/SortByColor.htm
Excel doesn't have a built in sort by color capability. Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "DHM" wrote: I entered rows of data and color coded the text in the rows. How do I sort the rows by color |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Color code
Excel 2007 claims to be able to do that. Prior versions cannot sort by color. A macro can do it, see... http://www.xldynamic.com/source/xld.ColourCounter.html - or - A commercial alternative (from yours truly)... http://www.officeletter.com/blink/specialsort.html. -- Jim Cone San Francisco, USA "DHM" wrote in message I entered rows of data and color coded the text in the rows. How do I sort the rows by color |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|