I have just finished reviewing an excel spreadsheet where a number of the rows were formatted with strikethough :
The formatting was valid and the rows have to stay there – but I have no need to review those rows. In excel you can filter rows, by contents or even by colour but not by format.
Enter a VBA user function:
Create a code module and paste in the following:
Function StruckThrough(R As Range) As Integer If R.Count = 1 Then StruckThrough = R.Font.Strikethrough End Function
You can then add a new column for example A:A and enter the formula
and then copy this down. Column A will then flag true or false if the cell to the right is struck through and you can now filter by this new column.