Changing Text format in a function

F

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 :cool:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Concantenate which keeps bold of some parts. 5
if/then changing text format to Bold 1
If Formula 10
COUNTIF: criteria is a format 4
bold text of referenced cell show in formula cell 1
Format part of text in concatenated field 4
formula cell format change 3
Returning the month (mmm) from cell in date format dd/mm/yyyy 1

Top