Format text within a cell

[Catherinefsimon]

Hello,

I am trying to format a certain part of text within a cell, ideally to another color, but bold would be fine.

Here is the original formula:, I'd like the first line to be either another color or bold. THANKS!

=CONCATENATE('programmi 07-08'!L69,":
",'programmi 07-08'!K69)

I've tried this but it doesn't work:
=CONCATENATE(TEXT('programmi 07-08'!L69,"bold"),":
",'programmi 07-08'!K69)

 

[Andrew Poulsom]

Sorry, but you can't apply rich text formatting to the result of a formula.