how do I filter on text format in Excel?

G

Guest

I have a workbook containing text that I wish to filter based on the format
of some words. IOW, for instance, all records (rows) with cells containing
text of a certain font color, or perhaps characters with the strikethrough
mark. I'm relatively familiar with advanced filtering, but this appears to be
something requiring a "filter by formula". Does anyone have any experience
in this area?
 
P

Peo Sjoblom

It is not in any built in function in Excel only way this would be possible
would be to use a UDF (a function written using VBA) in a help column
and then filtger on that help column plus the word itself. Next version of
Excel will have some of this built in.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA: How can I use a string variable as autofilter criteria? 4
Conditionally formatting text and numbers differently 1
How do I filter using multiple columns in Excel? 1
Conditional formatting in Excel 2007 - font choice grayed out 0
How do I do simultaneous AND and OR filtering ? 3
Formatting Selection of cells. 3
how do i filter a list greater than 1000 rows 1
In Excel, How do I get AutoFilter to provide# of records found? 1

Top