Excel Threads - Auto filter by background color.

Report thread as spam

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.

This question was started by infinitodd 7 years ago

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.

This response was posted by Bob Phillips 7 years ago

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

-- michael.a7

michael.a7's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=33027 View this thread: http://www.excelforum.com/showthread.php?threadid=528341

This response was posted by michael.a7 7 years ago

Auto filter by background color.

Other excel threads