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.
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.
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)
"infinitodd" <[email protected]> wrote in message
news:[email protected]...
> 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.
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%2...%20Filter.html
Michael
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks