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.

--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"Thomas" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>

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

On Feb 7, 3:08 pm, "Earl Kiosterud" <some...@nowhere.com> wrote:
> 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.
>
> --
> Earl Kiosterudwww.smokeylake.com