Is there a way to Sort data by color in Excel? in Excel General Questions    |   |  Help   Search For:     In:   Office   Excel     Excel General Questions     Excel New users     Excel Application Errors     Excel Charts     Excel Programming     Excel Setup     Excel Worksheet Functions              SRTUC 7/1/2005 8:51 AM PST   Question   I am trying to sort data by color, is that possible?     Was this post helpful to you?         Reply |   Top           Bob Phillips 7/1/2005 9:47 AM PST   Answer   see http://www.xldynamic.com/source/xld.ColourCounter.html#sorting -- HTH Bob Phillips "SRTUC" <SRTUC@discussions.microsoft.com> wrote in message news:B5121232-FB1D-46AF-94F8-04B7EAA2D90C@microsoft.com... > I am trying to sort data by color, is that possible?     Was this post helpful to you?         Reply |   Top           Dave Peterson 7/1/2005 10:39 AM PST   You're gonna need a User defined function to get the value of a color. See Chip Pearson's site for a nice version: http://www.cpearson.com/excel/colors.htm Look for: Returning The ColorIndex Of A Cell Then you could use that UDF in a separate column and sort by that column. SRTUC wrote: > > I am trying to sort data by color, is that possible? -- Dave Peterson     Was this post helpful to you?         Reply |   Top         Return to Microsoft Communities   Notify me of replies