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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting 2
Conditional Formatting 4
Conditional Formatting Row & Text 1
maxing out conditional formatting 1
concatenate & conditional formatting in one 1
Conditional Formatting - Code to colour 3+ text values differently 3
Formatting concatenated text 3
Format numbers returned in the function CONCATENATE 3

Back
Top