View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Neil Pearce Neil Pearce is offline
external usenet poster
 
Posts: 109
Default Filter based on Format?

Dear all,

Is it possible to filter based on format as well as content?

For example column A contains numbers. Filter column A for non-zero and
emboldened numbers?

Is there a function that I could use to do this with a helper column, e.g.
ISBOLD()?

=IF(AND(ISNUMBER(A1),ISBOLD(A1)),"show","hide")

Then filter for show only.

Your help would be much appreciated.


Kind regards,

Neil