software

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 quot;filter by formulaquot;. 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

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

cpearson.com/excel/SortByColor.htmIn article gt;,
Tinker gt; wrote:

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