View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Steve[_4_] Steve[_4_] is offline
external usenet poster
 
Posts: 184
Default Bold items within text string

Thanks Rick. I'm certainly willing, but have no idea how to do that!

On Jun 9, 11:36*am, "Rick Rothstein"
wrote:
Thanks Rick. *How about this - since the parts of the text string I
want bolded are constant (ie, column headers J$1:N$1), can I read
the column headers in variables, and do a FIND routine to find
each column header in the text string and then bold?


You cannot bold individual parts or text generated by a formula... there is
no way around that using formulas. If you were willing to turn the
calculating of the formula to VB in a Change event procedure, then you could
have that procedure inject pure text into the cell and that text, being a
constant, could be bolded in parts.

Rick Rothstein (MVP - Excel)