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
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.