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

R

Ruth

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?
 
G

Gary''s Student

You can't. Copy the concatenated cell as value and then re-apply the formats.
 

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

Need help modifying code 0
How to filter rows data based on background color of individual cells 3
Isolating part of text to use in an IF/AND FUNCTION 2
Multiple items selected multiple dependancies available 3
How can the font and size of (all) citation numbers be altered? 1
Unique Value Count in 3 Columns Using Search Criteria 0
Conditional formatting with vba 3
How do I convert shading to highlighting for specific colors 8

Top