View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom
 
Posts: n/a
Default 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?