Formatting a cell with a concatenated formula

  • Thread starter Thread starter andy2812
  • Start date Start date
A

andy2812

Sorry for the double post but I'm not sure which is the best forum fo
this question so I've posted it in 2 different ones.

I have a concatenated formula that pulls text from 2 different cells
The 2 cells are formatted differently (i.e. 1 cell has blue text an
the other cell has red text and a different font) and I want to kee
these formats. However, the cell with the concatenated formula take
the format of that cell. Is there anyway to do this
 
Hi
this is not possible with formulas. formulas only return values
 
You must log in or register to reply here.

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

Different formatting in a cell with a concatenated formula? 1
Concatenate multiple lines 2
Excel VBA 1
simple minus formula not working. 2
Conditional formatting based on formula cell 6
Conditional Formatting 1
Concatenate and Format of result... 2
Adding contents of a cell as the worksheet reference in a formula 4

Back
Top