Sort by Format?

D

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
 
A

Andy Brown

I received a sheet with a listing ...
Is it possible to sort the list by one or the other formats?
Click to expand...

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
 
Top