Auto filter by background color.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

infinitodd - 30 Mar 2006 23:48 GMT

I use the auto filter all the time. I'm looking to highlight, follow ups,
pendings, etc. then be able to use the drop down menu for "all red," "all
blue," etc.

I can't seem to figure out how to do it.

Reply to this Message

Bob Phillips - 30 Mar 2006 23:55 GMT

It's not easy. Ron de Bruin has developed an addin. Check it out at
http://www.rondebruin.nl/easyfilter.htm, bottom of the page.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

> I use the auto filter all the time. I'm looking to highlight, follow ups,
> pendings, etc. then be able to use the drop down menu for "all red," "all
> blue," etc.
>
> I can't seem to figure out how to do it.

Reply to this Message

michael.a7 - 31 Mar 2006 22:03 GMT

You can use a Custom Function to return the InteriorColor of a cell -
and then use this as your AutoFilter Criteria.

Type the following into VBA:

Function InteriorColor(CellColor As Range)
InteriorColor = CellColor.Interior.ColorIndex
End Function

And then in Excel type =InteriorColor(A1)

There is a very nice tutorial on Filters which includes an axample on
your question. Goto
http://www.excelexchange.com/Using%20Advanced%20Filter.html

Michael

Signature

michael.a7

Reply to this Message