Can i format part of the answer to a concatenation in a different colour? for
example: =concatenate(a1,a2,[red]a3,a4,a5)
there seems to be some sort of way using the custom cell format to use [red]
to change the colours, but i dont want it to apply to the whole text string,
just one word in it.
May not be possible but would be nice option :P

I don't believe it is possible.
--
Gary''s Student - gsnu200734


"Bretter99" wrote:

Can i format part of the answer to a concatenation in a different colour? for
example: =concatenate(a1,a2,[red]a3,a4,a5)
there seems to be some sort of way using the custom cell format to use [red]
to change the colours, but i dont want it to apply to the whole text string,
just one word in it.
May not be possible but would be nice option :P

I'm like Gary's Student: don't think it can be done in worksheet formula.
You could get it done with a user defined function, since you can go down to
even the single character properties in VBA - but I'm not sure I'd want to
try writing a truly robust routine to do that, something where you might
enter:
=UDF_ColorWords(a1,a2,[red]a3,[blue]a4,[yellow]A5,A6)


"Bretter99" wrote:

Can i format part of the answer to a concatenation in a different colour? for
example: =concatenate(a1,a2,[red]a3,a4,a5)
there seems to be some sort of way using the custom cell format to use [red]
to change the colours, but i dont want it to apply to the whole text string,
just one word in it.
May not be possible but would be nice option :P

After actually looking at things, I'm not sure but what this whole deal falls
into the category of "you can't get there from here". While we could use
VBA/UDF to manipulate individual characters in a cell with text in it,
doesn't seem that I can figure out how to do that with the results of a
formula evaluation.

"JLatham" wrote:

I'm like Gary's Student: don't think it can be done in worksheet formula.
You could get it done with a user defined function, since you can go down to
even the single character properties in VBA - but I'm not sure I'd want to
try writing a truly robust routine to do that, something where you might
enter:
=UDF_ColorWords(a1,a2,[red]a3,[blue]a4,[yellow]A5,A6)


"Bretter99" wrote:

Can i format part of the answer to a concatenation in a different colour? for
example: =concatenate(a1,a2,[red]a3,a4,a5)
there seems to be some sort of way using the custom cell format to use [red]
to change the colours, but i dont want it to apply to the whole text string,
just one word in it.
May not be possible but would be nice option :P