Help

[gledister]

Does anyone knows a method to filter by color?!

Thanks in advance!

 

[p45cal]

Excel version?

 

[gledister]

filter by color

anyone got any idea?

 

[JamesW]

Hi,

Excel 2007 introduced a sort by colour option. If you have an earlier version then you can create a UDF to do this.

Function getColour(cRange As Range)
    getColour = cRange.Interior.ColorIndex
End Function

Alt+F11 -> Insert -> Module -> Paste above -> Type =getColour(A1) into your cell.

The above will give you a numeric value which can then be sorted.

 

[gledister]

excel 2010

 

[gledister]

does excel 2010 have that option!?

 

[shg]

See http://office.microsoft.com/en-us/e...1.aspx#BMfilter_by_cell_color,_font_color,_or_

 

[JamesW]

Yes - http://office.microsoft.com/en-us/e...-in-excel-2010-HA101829993.aspx#_Toc256078355

 

[gledister]

thanks!