Combine Cells and Retain Color Fomatting

  • Thread starter Thread starter Thomas
  • Start date Start date
T

Thomas

Here is the issue I am trying to figure out.

*There are three cells, A2, A3, and A4 lets say.
*A4 contains black text only.
*A3 contains an arrow (special character) that, depending on the slope
of a line, will change to an up or down arrow thanks to conditional
formatting and will also change color based on whether or not the up/
down direction is a good/bad thing.
*I want to combine the contents of A3 and A4 in the same cell, namely
A2 and keep the color formatting of the arrow while the rest of the
text remains black.
*I am doing this so I can reference A2 for a chart label.

Any suggestions?

Thanks,

Thomas
 
Thomas, If a cell with mixed formatting is linked to a chart, the chart will not pick up
formatting (color, etc.) of the various characters in the cell. And a formula, such as the
one you want in A2, can't pick up formatting either.
I don't know how you're implementing the change from an up to down arrow with conditional
formatting, but I don't think it matters.

It's possible to have mixed formatting in a text box in a chart, and it the chart title,
axis titles, etc. So a macro could probably do the mixed formatting from the original cells
(A3 and A4). If you want to go that route, you might do better posting in
microsoft.public.excel.charting. You'll need to be specific about which part of the chart
you're trying to link to. Jon Peltier hangs around there, and is good with chart macro
stuff.
 
Thanks for the information. The arrow actually changes based on a
formula (IF(SLOPE("stuff") > 0, up arrow, down arrow))) and the
coloring is done via conditional formatting. I will post in the
suggested group!

Thanks,

Thomas
 
Back
Top