Consulting

Results 1 to 5 of 5

Thread: Sleeper: Function for BOLD format

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    VBAX Regular
    Joined
    Mar 2005
    Posts
    50
    Location

    Sleeper: Function for BOLD format

    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
    Last edited by brunces; 07-13-2005 at 06:53 AM. Reason: Edited for addtional comments.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •