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