Bold the number only in a concatenated with text formula...

M

MarvInBoise

I have this formula: =IF(K65>H65,"Download is "&ROUND(H65/K65,2)&" times
faster","Upload is "&ROUND(K65/H65,2)&" faster") and would like to bold the
result only and not the text, so just the H65/K65 or K65/H65 value. Can do?

Thanks!
 
C

CLR

ONe way to do what you want is to use three cells for your
"result".....having your leading text in one cell, your math result in the
one to the right of that, and your trailing text in the next one to the
right..............then you could not only BOLD the math result, you could
increase it's fontsize and/or change the color.

Vaya con Dios,
Chuck, CABGx3
 

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

Workaround for nesting more than 7 statements 2
Formating bolded text exclusively. 0
Macro to concatenate with previous bold cell 0
Concatenate and Bold 3
Bold paragraphs beginning with a number 0
MS Project. Real progress of the project, % complete 1
Managing Filtered Items 1
MROUND Help 1

Top