Changing Text format in a function

[FirstWizardZedd]

Hi Everyone,

I have a question. I formula that generates a string result that I would like to do some formating with. I would like to bold the text and change the text color. But I do not want to do it to the whole cell. Just a portion of the text.

Here is an example:
A1 = 4/3/2006
A3 = 1

Formula in B3
="Week "&A3&": " & TEXT($A$1+((A3-1)*7),"[RED][BOLD]Mmm d 'yy")

Formula Result in B3
Week 1: Apr 3 '06

I am trying to use the Text formula, but it does not recognize the color request.

Any help will be appreciated.
thanks
BDS

[Peo Sjoblom]

Not possible to format part of a formula


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"FirstWizardZedd"
<[email protected]> wrote in
message news:[email protected]...
>
> Hi Everyone,
>
> I have a question. I formula that generates a string result that I
> would like to do some formating with. I would like to bold the text and
> change the text color. But I do not want to do it to the whole cell.
> Just a portion of the text.
>
> HERE IS AN EXAMPLE:
> A1 = 4/3/2006
> A3 = 1
>
> _Formula_in_B3_
> ="Week "&A3&": " & TEXT($A$1+((A3-1)*7),"[RED][BOLD]Mmm d 'yy")
>
> _Formula_Result_in_B3_
> Week 1: *Apr 3 '06*
>
> I am trying to use the Text formula, but it does not recognize the
> color request.
>
> Any help will be appreciated.
> thanks
> BDS
>
>
> --
> FirstWizardZedd
> ------------------------------------------------------------------------
> FirstWizardZedd's Profile:
> http://www.excelforum.com/member.php...o&userid=33506
> View this thread: http://www.excelforum.com/showthread...hreadid=533003
>