sort column by colour
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 |
sort column by colour
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 |
sort column by colour
if u mean the text color use this
Cells(r, c + 1) = Cells(r, c).Font.ColorIndex "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 |
sort column by colour
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 On Fri, 21 Jul 2006 03:20:01 -0700, Martin wrote: 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 |
All times are GMT +1. The time now is 07:59 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com