Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 - |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel:Get concatenated text to be recognised as formula not text? | Excel Discussion (Misc queries) | |||
Join bold and non-bold text in one cell | Excel Discussion (Misc queries) | |||
format a number concatenated with text | Excel Discussion (Misc queries) | |||
Bold a portion of concatenated string | Excel Discussion (Misc queries) | |||
concatenated text to formula | Excel Discussion (Misc queries) |