Sorting a spreadsheet by strikethrough?
 

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 a spreadsheet by strikethrough?
 

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

On Wed, 4 Nov 2009 07:01:01 -0800, Nicol
wrote:

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