brunces
07-13-2005, 05:51 AM
Friends,
Please, is there any function in Excel for BOLD format?
I have a formula like this...
="There are "&B10&" users in the room now!"
I want only the "number of users (B10)" in BOLD format, so I'd like to know if there's a function to do that. It would be something like this...
="There are "&BOLD(B10)&" users in the room now!"
If there's not, how could I create this function in VBA?
A friend of mine told me it's impossible to do. But, wouldn't it be the same process of the functions UPPER(range) and LOWER(range)? I mean, if it's possible to deal with upper or lower cases using functions, maybe it's possible to deal with bold format as well, ain't it? Am I wrong?
When the value of a cell is a text, it's possible to put bold format only for the words we want, instead of putting for the (entire) cell intself. But when the cell has a formula, that's not possible anymore. That's why I thought about a function. :)
Is it really impossible?
Thanks for the attention, guys.
Hugs. :)
Bruno
Please, is there any function in Excel for BOLD format?
I have a formula like this...
="There are "&B10&" users in the room now!"
I want only the "number of users (B10)" in BOLD format, so I'd like to know if there's a function to do that. It would be something like this...
="There are "&BOLD(B10)&" users in the room now!"
If there's not, how could I create this function in VBA?
A friend of mine told me it's impossible to do. But, wouldn't it be the same process of the functions UPPER(range) and LOWER(range)? I mean, if it's possible to deal with upper or lower cases using functions, maybe it's possible to deal with bold format as well, ain't it? Am I wrong?
When the value of a cell is a text, it's possible to put bold format only for the words we want, instead of putting for the (entire) cell intself. But when the cell has a formula, that's not possible anymore. That's why I thought about a function. :)
Is it really impossible?
Thanks for the attention, guys.
Hugs. :)
Bruno