sort column by colour

[Guest]

Hello, I have been given a rather large database sheet in Excel and some of
the line records have been coloured red, green and standard black. Is there a
way I can sort the records by colour i.e. red first the green then black?

Any tips or ideas most welcome Thanks Martin

 

[Guest]

if column right to colored cells is free:
select column where ur colored cells are - run sub

Sub farve()
c = ActiveCell.Column
For r = 1 To 100
Cells(r, c + 1) = Cells(r, c).Interior.ColorIndex
Next

then sort sub after created numbers

"Martin" skrev:

 

[Guest]

if u mean the text color use this

Cells(r, c + 1) = Cells(r, c).Font.ColorIndex

"Martin" skrev:

 

[Gord Dibben]

Martin

Excel cannot do this without help.

See Chip Pearson's site for code.

http://www.cpearson.com/excel/SortByColor.htm

Or Bob Phillips' site

http://www.xldynamic.com/source/xld.ColourCounter.html


Gord Dibben MS Excel MVP