For example, there are 100(row) x 20(column) cells in a sheet, and every single cell has 5 lines. Some lines are in red, some are marked with strike-through, etc. How can I search all lines in red? How can I find all lines with strike-through? How can I search only by SearchFormat
?
I've tried the Excel find with format
, but it doesn't work for part of a cell. If all 5 lines are in red, it can find them; but if only 2 lines in red and other 3 lines are normal, it can't find the 2 lines, even when match entire cell contents
is not checked.