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!