View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Filter by Format

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

petess wrote:

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