Sort rows by color

[Chris]

Is there a way in office 2000 to sort rows by color? I'm not good with code
and cutting and pasting over 1000 rows is becoming tiresome.

Thanks

 

[Bernie Deitrick]

Text color or background color?

Use a UDF - copy and paste this into a codemodule:

Function BGColor(myR As Range) As Integer
BGColor = myR.Interior.ColorIndex
End Function
Function FColor(myR As Range) As Integer
FColor = myR.Font.ColorIndex
End Function


Then use them like so

=BGColor(A2)
=FColor(A2)

depending on whether you want BackGroundColor or FontColor.

Copy the formula down to match your cells, then sort based on that column.

HTH,
Bernie
MS Excel MVP

 

[Chip Pearson]

Chris,

Excel 2007 added this capability. For earlier versions, see
http://www.cpearson.com/excel/SortByColor.htm for example code to do this.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)