Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Alphabetically list of last names: BOLD, not bold | Excel Discussion (Misc queries) | |||
Alphabetically list of names BOLD and NOT bold | Excel Discussion (Misc queries) | |||
Sort by Bold data | Excel Discussion (Misc queries) | |||
Join bold and non-bold text in one cell | Excel Discussion (Misc queries) | |||
Excel subtotals, add a sort option, and BOLD the function answers | New Users to Excel |