Portion of concatenate formula to have different color and font fo
 

I'm using the following formula: ="Manufacturer's Name"&CHAR(10)&"See "&D3&",
"&"City, State"

where the value in D3 is "Ref#" such that the result is:

Manufacturer's Name
See Ref#, City, State

and I want the value in D3, i.e. "Ref #" to be bold and blue, whereas the
rest of the text should be black and not bold.

The precise color blue that I want has the values: Red: 0, Green: 50, Blue:
210

Also, the cell D3 (that says "Ref#) is formatted exactly how I want it--blue
and bold. So basically, I just want the formula to carry over the same
format from that cell for that portion of the concatenation.

I'm not sure if this is impossible. If not, please help--thanks!

Not possible to change the format of parts of a formula result

--

Regards,

Peo Sjoblom

"Colleen B" wrote in message
...
I'm using the following formula: ="Manufacturer's Name"&CHAR(10)&"See
"&D3&",
"&"City, State"

where the value in D3 is "Ref#" such that the result is:

Manufacturer's Name
See Ref#, City, State

and I want the value in D3, i.e. "Ref #" to be bold and blue, whereas the
rest of the text should be black and not bold.

The precise color blue that I want has the values: Red: 0, Green: 50,
Blue:
210

Also, the cell D3 (that says "Ref#) is formatted exactly how I want
it--blue
and bold. So basically, I just want the formula to carry over the same
format from that cell for that portion of the concatenation.

I'm not sure if this is impossible. If not, please help--thanks!