Sort by Format?

[data_gnome]

Hi all!
I received a sheet with a listing of clients, serviced by tw
locations.
One location's clients are typed in ALL CAPS while the other is not bu
is in *bold* type.

Is it possible to sort the list by one or the other formats?

Thanks
Al Davis
:cool

 

[Andy Brown]

I received a sheet with a listing ...

Is it possible to sort the list by one or the other formats?

Don't think so. You could add a column for "Bold/Caps", then run a macro
such as

For Each Cell In Selection
If Cell.Font.Bold = True Then
Cell.Offset(0, 1) = "Bold"
Else
Cell.Offset(0, 1) = "Caps"
End If
Next Cell

And then sort by the added column.

HTH,
Andy