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
|