sort by bold?
 

Anyone have a macro that will allow me to sort by whether a cell is bold or
not? Using Excel2003.

Thanks,
JM

sort by bold?
 

Joe,

You need a helper column, and use a UDF to determine if bold

Function IfBold(rng As Range)
IfBold = rng.Font.Bold = True
End Function

and in the adjacent column use

=IfBold(A1) and copy down.

Then sort on that column.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Joe Murphy" wrote in message
...
Anyone have a macro that will allow me to sort by whether a cell is bold
or
not? Using Excel2003.

Thanks,
JM