Formating text in a calculation

  • Thread starter Thread starter Tim
  • Start date Start date
T

Tim

I have a formula that looks like this:

=CONCATENATE("Placement of ",B7, " inch, ",ROUND(B9,2),"% lime stabilized
subgrade")

I need the cell references to stand out, so I want to format only the two
numbers to underline, boldface, and a larger font size. Is there a way to do
this?

Thanks in advance
 
PARTS of formulas cannot be a different color -- it's all or none. Different
formatting is only for constant values, not formulas.
Bob Umlas
Excel MVP
 
Sorry, but Excel does not allow you to separately format subsets of a
formula's result
 

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

Conditionally formatting numeric data and text differently 1
Is there a function that tells if text in cell is boldfaced? 2
Text Format 2
Format Concatenate Entries 2
ROUNDDOWN(IF( ...)) CALCULATION 6
Format part of text in concatenated field 4
Payment calculation 1
How to format Text by function 5

Back
Top