Concatenate and Conditional Formatting

  • Thread starter Thread starter Sliver Rayne
  • Start date Start date
S

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
 
First copy the result of the formula and paste it as Special > Value. Then
you can format the individual sections of the text.
 
Back
Top