Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
filter or format based on criteria in more than one column | Excel Worksheet Functions | |||
Filter based on Pivot table | Excel Worksheet Functions | |||
Filter based value in multiple columns | Excel Discussion (Misc queries) | |||
Filter based on a column of items | Excel Discussion (Misc queries) | |||
How can i filter dates based on day of month | Excel Worksheet Functions |