sort column by colour

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Martin - 21 Jul 2006 11:20 GMT

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

Reply to this Message

excelent - 21 Jul 2006 14:10 GMT

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:

> 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

Reply to this Message

excelent - 21 Jul 2006 14:13 GMT

if u mean the text color use this

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

"Martin" skrev:

Reply to this Message

Gord Dibben - 21 Jul 2006 22:36 GMT

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

>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

Reply to this Message