You could add a helper column and determine the colorindex in that column,
and filter on that column.

A colorindex function is available at
http://www.xldynamic.com/source/xld.ColourCounter.html

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Javid" wrote in message
...
Hi
how can I filter by colors in Excel?
Fallah