Filter by Format

[petess]

I have colored certain cells in a given column.

I am trying to filter by color for that column, so that once filtered, only
rows displaying cells with the given color in the specified column are
visible. Once filtered I hope to perform calculations on numerical data in
associated columns.

Would appreciate advice on solving this, as I cannot find the right place to
look in Help.

Thank you.

petess

 

[Dave Peterson]

If the coloring was not added by conditional formatting...

In xl2007, you could use autofilter. It's a new feature!

In earlier versions, look at Ron de Bruin's site:
http://www.rondebruin.nl/easyfilter.htm