Multiple colors in Excel Cell?

[hoganator]

It is possible to select a portion of text in the formula bar and select a certain color, and then select a different portion of text in the same cell to select a different color, for example:

This is the first, and this is the other part, and yet another.

That can be viewed in the same cell, colors and all.
However, my question is: Can i do this with a formula? such as in using the concatenate function, or something else?

I know a little of custom formatting, but I can't quite seem to get that to work right with strings.

Any help would be much appreciated.

 

[GlennUK]

No you can't, not with formulas.

You would have do something with macros to this kind of thing.

Sorry, Glenn.

 

[hoganator]

OK, well what about with formatting? Can you say i want this cell to be formatted with such and such number of characters as this color, and then the rest as this color? Or, can you choose only one color per cell that way as well?

 

[DrBowes]

This can be done with formatting very easily, just select the part of the cell you want to format and go to format cells as usual.

You can also have parts bold, different sized fonts or whatever you want in the same way.