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

I have this formula: =IF(K65H65,"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!
--
Marv Lusk

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

Not within a formula - you would need to use VBA to achieve that
effect.

Pete

On Jan 11, 4:48*pm, MarvInBoise
wrote:
I have this formula: *=IF(K65H65,"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!
--
Marv Lusk

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

DANG, thanks!
--
Marv Lusk
Boise Corporation


"Pete_UK" wrote:

Not within a formula - you would need to use VBA to achieve that
effect.

Pete

On Jan 11, 4:48 pm, MarvInBoise
wrote:
I have this formula: =IF(K65H65,"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!
--
Marv Lusk

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

You're welcome. Sorry to be the bearer of bad news! <bg

Pete

On Jan 11, 5:02*pm, MarvInBoise
wrote:
DANG, thanks!
--
Marv Lusk
Boise Corporation



"Pete_UK" wrote:
Not within a formula - you would need to use VBA to achieve that
effect.

Pete

On Jan 11, 4:48 pm, MarvInBoise
wrote:
I have this formula: *=IF(K65H65,"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!
--
Marv Lusk- Hide quoted text -

- Show quoted text -

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

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



"MarvInBoise" wrote:

I have this formula: =IF(K65H65,"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!
--
Marv Lusk