sorting using formatting criteria

S

Steve Piper

Is it possible to sort a spreadsheet using formatting as a criteria. I
have a spreadsheet with thousands of rows, and the fonts for several of the
rows have been changed to indicate edited rows.
Steve
 
F

Frank Kabel

Hi Steve
this would be only possible using VBA. e.g. returning some formating
info through a user defined function in a helper column and sorting
this helper column.

For example try the following to check of a bold font:
Public Function Is_Bold(rng As Range) As Boolean
Dim vTemp As Variant
Application.Volatile
vTemp = rng.Font.Bold
If IsNull(vTemp) Then vTemp = False
Is_Bold = vTemp
End Function

use this function in a helper column like
=IS_BOLD(A1)
copy down and search this column
 
Top