| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I reatin the color of text when I use a formula
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I reatin the color of text when I use a formula
You can't. Copy the concatenated cell as value and then re-apply the formats.
-- Gary''s Student - gsnu200758 "Ruth" wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Color of text relating to a formula | Excel Worksheet Functions | |||
| Changing text color within a formula??? | Excel Discussion (Misc queries) | |||
| Cond. format text color based on another's text color | Excel Discussion (Misc queries) | |||
| How do I use a formula to make certain text a different color? | Excel Worksheet Functions | |||
| Formula that tests text color | Excel Discussion (Misc queries) | |||
Linear Mode
