Portion of concatenate formula to have different color and font fo

C

Colleen B

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!
 

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

sum total of numbers that are a certain color? 3
Use Text and Cell vale to reference a named range inside a formula 4
Format part of text in concatenated field 4
Formula to lookup product name and add qty's of all that are found 1
Identify external references (in formulas) and color format 9
Cell Color Recognition and Summing of Data Within a Specified Colo 1
Different colors within on cell. 3
Referencing formula using Indirect 4

Top