Forum Discussion
filter by strikethrough
I want to filter an Excel file, showing those cells that contain strikethrough text. I cannot find a way to do this, even in Advanced. How should I do it? Excel Professional Plus 2013 (32 bit), W...
Hi,
Here are 3 methods how to do that https://trumpexcel.com/filter-bold-font-formatting-in-excel/. Samples are for the bold text, but you case is identical. If Get.Cell first parameter will be 23 instead of 20 https://www.mrexcel.com/forum/excel-questions/20611-info-only-get-cell-arguments.html
So GET.CELL does what it says on the tin; it gets the properties form a single cell only. I tried giving it the entire column from the table as the reference but the function only returned a single value so it was no use for the FILTER function.
A hidden helper column in the Table did the trick though.
Hi Peter - yes, that's with helper column.