cell color

[rapgame]

Following microsoft.com one of the differences between excel 2000 and 2007 is
the feature filtering on cell color instead of text only.

So I am using Excel 2000, please understand that updating to 2007 is to
expensive. I just want to been able to filter on cell color. Are there any
other solutions, for example a plugin/addin or something.

Thanks in advance.

Robert

 

[Jarek Kujawa]

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

 

[Bob Phillips]

http://www.rondebruin.nl/easyfilter.htm

has an option to filter on colour.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Gord Dibben]

Copy Chip Pearson's ColorIndexOfCell function then filter by the index number
returned from the formulas.

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


Gord Dibben MS Excel MVP