software

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_
=quot;Week quot;amp;A3amp;quot;: quot; amp; TEXT($A$1 ((A3-1)*7),quot;[RED][BOLD]Mmm d 'yyquot;)

_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: www.excelforum.com/member.php...oamp;userid=33506
View this thread: www.excelforum.com/showthread...hreadid=533003Not possible to format part of a formula--

Regards,

Peo Sjoblom

nwexcelsolutions.com
quot;FirstWizardZeddquot;
lt;FirstWizardZedd.269ooc_1145039702.6453@excelfor um-nospam.comgt; wrote in
message news:FirstWizardZedd.269ooc_1145039702.6453@excelf orum-nospam.com...
gt;
gt; Hi Everyone,
gt;
gt; I have a question. I formula that generates a string result that I
gt; would like to do some formating with. I would like to bold the text and
gt; change the text color. But I do not want to do it to the whole cell.
gt; Just a portion of the text.
gt;
gt; HERE IS AN EXAMPLE:
gt; A1 = 4/3/2006
gt; A3 = 1
gt;
gt; _Formula_in_B3_
gt; =quot;Week quot;amp;A3amp;quot;: quot; amp; TEXT($A$1 ((A3-1)*7),quot;[RED][BOLD]Mmm d 'yyquot;)
gt;
gt; _Formula_Result_in_B3_
gt; Week 1: *Apr 3 '06*
gt;
gt; I am trying to use the Text formula, but it does not recognize the
gt; color request.
gt;
gt; Any help will be appreciated.
gt; thanks
gt; BDS
gt;
gt;
gt; --
gt; FirstWizardZedd
gt; ------------------------------------------------------------------------
gt; FirstWizardZedd's Profile:
gt; www.excelforum.com/member.php...oamp;userid=33506
gt; View this thread: www.excelforum.com/showthread...hreadid=533003
gt;