Can i format (colour) selective text in a cell using excel2000?
 

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

Can i format (colour) selective text in a cell using excel2000?
 

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

Can i format (colour) selective text in a cell using excel2000?
 

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

Can i format (colour) selective text in a cell using excel2000
 

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