I entered rows of data and color coded the text in the rows. How do I sort the rows by color
D DHM Feb 7, 2007 #1 I entered rows of data and color coded the text in the rows. How do I sort the rows by color
D Dave F Feb 7, 2007 #2 You need a macro: http://www.cpearson.com/excel/SortByColor.htm Excel doesn't have a built in sort by color capability. Dave
You need a macro: http://www.cpearson.com/excel/SortByColor.htm Excel doesn't have a built in sort by color capability. Dave
J Jim Cone Feb 7, 2007 #3 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" <[email protected]> wrote in message I entered rows of data and color coded the text in the rows. How do I sort the rows by color
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" <[email protected]> wrote in message I entered rows of data and color coded the text in the rows. How do I sort the rows by color
