Hi
You can use edit - serch instead of filter. In the search you can chose the
format you want to find, and then you can search for all matches.

Mia

"Jrufin" skrev:

Hello,
I have a column of data (data are numbers and text) in Excel (around 1000+
items) and they have different font, font size and color. How to use
Autofilter/Advance Filter or any other means, to filter out say all items
that are RED in color, or items with Times Roman as Font, or items with Font
size 10.
Pls help!

Thanks.