Sorting a spreadsheet by strikethrough?

  • Thread starter Thread starter Nicol
  • Start date Start date
N

Nicol

I am wondering if you can sort as spreadsheet by the strikethrough's that are
in a column.

I know you can sort by color, alpha etc. But I have several strikethroughs
in a column and I would like those to be sorted as well.

Thanks
 
Sorting or Filtering?

I don't know how you would Sort by strikethrough since strikethrough has no
hierarchy to it.

Same with colors.............how would you sort by color unless you had a
helper column with the colorindex numbers?

To filter for cells that have strikethrough format you can use this UDF

Public Function IsStrike(rngRange As Range)
If rngRange.Font.Strikethrough = True Then
IsStrike = 1
End If
End Function

In a helper column enter =IsStrike(cellref)

Copy down the column and filter on 1 or 0


Gord Dibben MS Excel MVP
 
Back
Top