Concatenate and Conditional Formatting

[Sliver Rayne]

Below is an example of my concatenate:
=CONCATENATE(" ",(A34), " produced ", "Total Sales of ",
DOLLAR(O81,0), ...............................

Result would be: Tick Promo (red/bold text) - produced total sales of -
(normal/black text) - $100 (red/bold).

I want to have the output of the cell reference to be bold and red but the
rest of the text to remain normal, black. Any ideas?

Karrie

 

[Gary''s Student]

First copy the result of the formula and paste it as Special > Value. Then
you can format the individual sections of the text.