cell color
Excel 2003, should work in Excel 2000 as well
to simply filter on cell colors you might use the following function:
Function kolor(cell As Range) As Integer
kolor = cell.Interior.ColorIndex
End Function
press Alt+F11
then Insert-Module
and paste the a/m code
presume you want to determine color of A1
then in B1 insert the following:
=kolor(A1)
copy down and apply autofilter
HIH
|