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?
|