Thread: cell color
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jarek Kujawa[_2_] Jarek Kujawa[_2_] is offline
external usenet poster
 
Posts: 896
Default 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