Results 1 to 8 of 8

is it poss to make BOLD text within formula?

This is a discussion on is it poss to make BOLD text within formula? within the Excel Questions forums, part of the Question Forums category; I've formula like : =if(A1>15000,concatenate("looking to scenerio the amount will be ",B1),A1) Iwant to see the result of this formula ...

  1. #1
    Board Regular vipulgos's Avatar
    Join Date
    Aug 2002
    Location
    India
    Posts
    272

    Default is it poss to make BOLD text within formula?

    I've formula like :
    =if(A1>15000,concatenate("looking to scenerio the amount will be ",B1),A1)
    Iwant to see the result of this formula as under:
    "looking to scenerio the amount will be 25000"
    (25000 is the figure in cell B1)
    is it possible?

  2. #2
    MrExcel MVP Tom Urtis's Avatar
    Join Date
    Feb 2002
    Location
    San Francisco, California USA
    Posts
    11,008

    Default Re: is it poss to make BOLD text within formula?

    Not possible in the literal context you described. Individual character formatting cannot be applied to values in cells that are returned by formulas within such cells that contain formulas. This is because formatting is applied to a specific character location, and such locations vary depending on the result of the formula. There is no way for Excel to know in advance how to format a result it doesn't know yet.

    The only workaround is an event that basically enters the formula, converts it to a value constant, and formats the characters of that constant based on criteria you predetermine. Even then, no formula would actually exist in the cell except for a split second, during which time no formatting exists. The end result is possible with some imaginative coding of what are essentially constant cells.

  3. #3
    Board Regular vipulgos's Avatar
    Join Date
    Aug 2002
    Location
    India
    Posts
    272

    Default Re: is it poss to make BOLD text within formula?

    is it possible by vbcode?

  4. #4
    MrExcel MVP Tom Urtis's Avatar
    Join Date
    Feb 2002
    Location
    San Francisco, California USA
    Posts
    11,008

    Default Re: is it poss to make BOLD text within formula?

    I edited my first response for spelling when you replied. Yes it is possible with VBA code (not VB as you asked). See my suggestion in the second paragraph of my post for the approach.

  5. #5
    Board Regular
    Join Date
    Mar 2002
    Posts
    73

    Default Re: is it poss to make BOLD text within formula?

    I know this is not exactly it but what I do is take the calculation part and place that in another cell where I format it exactly the way I want. Then I use the camera tool an take a picture of it and place the picture in the cell where I want to ultimately display and apply proper spacing. This way the formula updates as needed and the camera tool will show the updated results in the format you choose.
    Thank you very much
    Spichael

  6. #6
    New Member
    Join Date
    May 2011
    Posts
    1

    Default Re: is it poss to make BOLD text within formula?

    Then I use the camera tool an take a picture of it and place the picture in the cell where I want to ultimately display and apply proper spacing.
    is that really working? what camera tools do you use?

  7. #7
    Board Regular T. Valko's Avatar
    Join Date
    May 2009
    Location
    Pittsburgh
    Posts
    16,133

    Default Re: is it poss to make BOLD text within formula?

    Quote Originally Posted by davbrwn View Post
    is that really working? what camera tools do you use?
    See this...

    http://spreadsheetpage.com/index.php...e_camera_tool/
    .
    Biff
    Microsoft MVP - Excel

    Using Excel 2002, 2007
    KISS - Keep It Simple Stupid

  8. #8
    New Member
    Join Date
    Jan 2013
    Posts
    4

    Default Re: is it poss to make BOLD text within formula?

    Quote Originally Posted by T. Valko View Post

    Wow. This amazing. I never paid attention the the linked picture before, as I never had a "picture" I had wanted to link. Getting the explanation and providing a way to sometimes format within a formula cell is absolutely fantastic. Thank you for providing this information.

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com