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" wrote in message
...
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.