Thank you everyone for all of your helpful suggestions.
Though you are correct that a macro might do the job, I was just looking for
a simple fix and at least now I have my answer.
Thank you once again - Jenny B.
"Dave Peterson" wrote:
> Just to make clear...
>
> This won't work with a formula--if Jenny converts the formulas to values, then a
> technique like this will work.
>
> bj wrote:
> >
> > I miss read your posting.
> > you can write a macro to change part of a text field to bold or to a color
> > font. but you have to be able to lengths of each section
> >
> > with your example the macro might be something like the macro below if the
> > length of the stuff to be bolded were 36
> > note you would nneed ot save and paste as values first
> > sub bld()
> > Range("K15").Select
> >
> > With ActiveCell.Characters(Start:=1, Length:=63).Font
> > .Name = "Arial"
> > .FontStyle = "Regular"
> > .Size = 10
> > .Strikethrough = False
> > .Superscript = False
> > .Subscript = False
> > .OutlineFont = False
> > .Shadow = False
> > .Underline = xlUnderlineStyleNone
> > .ColorIndex = xlAutomatic
> > End With
> > With ActiveCell.Characters(Start:=64, Length:=36).Font
> > .Name = "Arial"
> > .FontStyle = "Bold"
> > .Size = 10
> > .Strikethrough = False
> > .Superscript = False
> > .Subscript = False
> > .OutlineFont = False
> > .Shadow = False
> > .Underline = xlUnderlineStyleNone
> > .ColorIndex = xlAutomatic
> > End With
> > With ActiveCell.Characters(Start:=101, Length:=125).Font
> > .Name = "Arial"
> > .FontStyle = "Regular"
> > .Size = 10
> > .Strikethrough = False
> > .Superscript = False
> > .Subscript = False
> > .OutlineFont = False
> > .Shadow = False
> > .Underline = xlUnderlineStyleNone
> > .ColorIndex = xlAutomatic
> > End With
> > End Sub
> >
> > "bj" wrote:
> >
> > > what version of excel are you using. it does not work in 2003
> > >
> > > "Jenny B." wrote:
> > >
> > > > Good Afternoon All,
> > > >
> > > > I currently have a formula that pulls data results from one page and places
> > > > them in another along with additional text. I've seen several posts that
> > > > note bolding one word is not possible and I'm just wondering if that is in
> > > > fact correct. I've been able to change single words to Caps if needed (see
> > > > Exp. 1), but I'm able to just write Bold and get the same results (Exp. 2).
> > > >
> > > > Thank you for your review as always and appreciate any thoughts or advice -
> > > > Jenny B.
> > > >
> > > > Exp. 1 (Works)
> > > > ="This questionnaire asks you to evaluate the job performance of" &" " &
> > > > Upper('Test Results Data'!G49) & " " &Upper('Test Results Data'!F49) &"." &"
> > > > " & "The information you are providing is for research purposes only, and
> > > > will not become part of the employee's official record."
> > > >
> > > > Exp.2 (Does not Work)
> > > > ="This questionnaire asks you to evaluate the job performance of" &" " &
> > > > Bold('Test Results Data'!G49) & " " &Bold('Test Results Data'!F49) &"." &" "
> > > > & "The information you are providing is for research purposes only, and will
> > > > not become part of the employee's official record."
>
> --
>
> Dave Peterson
>
|
Similar Threads
