Concatenate: Italicize (or bold) part of output

[UDcc123]

I have a concatenate formula to output into a cell something like "100% / 75% / (25%)" (code is below).

I'd like to either bold or italicize that 25%...something to show that the (25%) is a variance and not a raw value.

It needs to be something other that "red" font since sometimes the variance is positive and I still want it highlighted somehow.

Thoughts?

=CONCATENATE(TEXT(L65,"0.0%")," / ",TEXT(C65,"0.0%")," / ",TEXT(C65-L65,"0.0%;(0.0%)"))

 

[Fluff]

The only way you could do that is with VBA & you would have to replace the formula with a hard value.

 

[UDcc123]

The only way you could do that is with VBA & you would have to replace the formula with a hard value.

Ok...thanks for the quick response!

 

[Fluff]

You're welcome & thanks for the feedback