How do I reatin the color of text when I use a formula

G

Guest

I have a column of data in red font and a column of data in a blue font. I
then use concatenate to merge the a cell from each column into one. The
returned value however appear in black. How do I keep half in red and half in
blue?
 

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

Change Color of cell 3
Isolating part of text to use in an IF/AND FUNCTION 1
Can I use a macro for color coding? 6
how do i use the text in a cell as a named range in a vlookup form 2
Formula question 3
automatic font color 2
Font color dipicts which formula to use 2
COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2

Top