Filter according to color

[#BoB#]

Hi,

Can anyone tell my if a macro can be created to filter data according to the interior color of the cells?


~ChillaX!!!

 

[Andrew Poulsom]

This shows you how to sort by colour:

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

AutoFilter would also be possible.

 

[Domski]

Hi,

You could use a UDF to return the colour like:

Function FillColour(mycell As Range)
Application.Volatile
FillColour = mycell.Interior.ColorIndex
End Function

Which would return the colour index of the interior colour of the cell.

You could then filter on that.

Dom

 

[#BoB#]

Thanks Gentlemen...


~ChillaX!!!