How can I filter on rows that are shaded in a different color?

[Guest]

How can I filter on rows that are shaded in a different color?

 

[Ron de Bruin]

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