Hi Frank

In Excel 2007 this is possible but not built-in in older versions.

You can use my add-in if you want
http://www.rondebruin.nl/easyfilter.htm

Or see
http://www.cpearson.com/excel/colors.htm
And
http://www.xldynamic.com/source/xld.ColourCounter.html


--

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


"Frank" wrote in message ...
How can I filter on rows that are shaded in a different color?