Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formating text in a calculation
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formating text in a calculation
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 "Tim" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formating text in a calculation
Sorry, but Excel does not allow you to separately format subsets of a
formula's result "Tim" wrote: 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formating text in a calculation
put that in 3 cells and you could do it :)
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding Dashes in front of text using text formating | Excel Discussion (Misc queries) | |||
Text Formating | Excel Worksheet Functions | |||
Text Formating | Excel Discussion (Misc queries) | |||
Text formating | Excel Discussion (Misc queries) | |||
Formating a text string? | Excel Discussion (Misc queries) |