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

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

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)

"rapgame" wrote in message
...
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

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

On Tue, 15 Jul 2008 01:54:00 -0700, rapgame
wrote:

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