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.


--

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?

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?