how do I filter on text format in Excel?

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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
Macro to work list in filter and save 1
How do I filter using multiple columns in Excel? 1
How to bind filtered data in list box? 1
Conditional formatting in Excel 2007 - font choice grayed out 0
How do I do simultaneous AND and OR filtering ? 3
Trouble with Advanced Filter 10
In Excel, How do I get AutoFilter to provide# of records found? 1

Back
Top