how do I filter on text format in Excel?
 

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?

how do I filter on text format in Excel?
 

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.


--

Regards,

Peo Sjoblom

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

how do I filter on text format in Excel?
 

Take a look he

http://cpearson.com/excel/SortByColor.htm


In article ,
Tinker wrote:

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?