This is a new option in Excel 2007/2010

For a older version you can try this add-in
http://www.rondebruin.nl/easyfilter.htm



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm



"dwake" wrote in message ...
Is it possible to filter by color, or to use a pivot table and be able to
filter by color?