Formatting Text Bold within a formula

Thanks Thanks:  0
Likes Likes:  0
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: Formatting Text Bold within a formula

  1. #1
    Board Regular
    Join Date
    Jan 2003
    Location
    Rock, Ks
    Posts
    629
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Formatting Text Bold within a formula

     
    Hi All,

    Is it possible to format this text created with formula below as BOLD?


    TEXT(5000+Deductible_Choice,"$#,##0")

    I would like to make just this part of the formula, which is listed below, to be bold so that it will stand out from the other text created.

    ="The amount of Covered Expenses needed before Fortis Health pays 100% - "&TEXT(5000+Deductible_Choice,"$#,##0")

    Here is the result of the formula and what I want it to look like:

    The amount of Covered Expenses needed before Fortis Health pays 100% - $5,500

    Cheers to all,
    Ken

  2. #2
    MrExcel MVP
    Moderator
    Andrew Poulsom's Avatar
    Join Date
    Jul 2002
    Posts
    73,092
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Formatting Text Bold within a formula

    Sorry, but you can't apply rich text formatting to the result of a formula.

  3. #3
    Board Regular
    Join Date
    Jan 2003
    Location
    Rock, Ks
    Posts
    629
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Formatting Text Bold within a formula

    Ok....thanks for the quick response!

    Ken

  4. #4
    Board Regular
    Join Date
    Mar 2002
    Posts
    73
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Formatting Text Bold within a 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 was the formula updates as needed and the camera tool will show the updated results in the format you choose.
    Thank you very much
    Spichael

  5. #5
    Board Regular
    Join Date
    May 2007
    Posts
    62
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Formatting Text Bold within a formula

    I have a similar problem, not sure if the answer will be any different. I have the following statement in a cell:

    ="Mix for " &F13&" at room temperature."

    Is it possible to just make the value coming from F13 appear bold?

    So for example to have the result be:

    "Mix for 10 minutes at room temperature."

    With "10 minutes" being the only thing displayed bold?

    Thanks!

  6. #6
    Board Regular crook_101's Avatar
    Join Date
    Oct 2008
    Location
    Home: Sunny England Work: Rainy Scotland
    Posts
    682
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Formatting Text Bold within a formula

    Hi,

    As Andrew's post above, this is not possible

    Regards,
    Ian
    There is no such thing as a stupid question. Anon

    But, if you work for me and ask a really stupid question, I will either laugh heartily or you get a really stupid answer

  7. #7
    New Member
    Join Date
    May 2012
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Formatting Text Bold within a formula

    Finally, something that worked for me...

    I needed to reference values in other cells and also be able to control the text formatting. This is what I first tried which didn't work:
    • Cell A1 = "First Name", in bold
    • Cell B1 = "John", in regular font
    • Cell Z1 = A1&": "&B1


    The resulting text was "First Name: John" with everything appearing in regular font, but I needed "First Name:" to be in bold.

    To make it work, I linked a text box to a cell (http://www.exceltip.com/st/Linking_a...Box/184.html):
    • Cell Z1 = A1 and formatted the cell contents as bold
    • Created a text box, clicked [F2] to link it to Cell B1, selected "No Line" for the text box formatting, and ensured the font was set to "regular".
    • Position the text box.


    The only tricky part was making sure the text box fit in the row and the text was aligned with the text below.

  8. #8
    Board Regular
    Join Date
    May 2007
    Posts
    62
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Formatting Text Bold within a formula

    I hope you haven't been working on that for the last 13 months...

  9. #9
    New Member
    Join Date
    May 2012
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Formatting Text Bold within a formula

    no, just a few days. This was the first thread that I read when googling.

  10. #10
    New Member
    Join Date
    Mar 2012
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Formatting Text Bold within a formula

      
    I found one step better.
    By inserting a Text box and shapes one can get a pretty flexible arrangement of formatted text and formulas.
    Step 1) Enter each variable/formula you would like to use into a cell on the page you want it to display from. [There are several methods to hide these later if needed]
    Step 2) Insert a textbox
    Step 3) Insert 1 rectangle shape for each variable/formula to display from step 1
    Step 4) For each shape, click on the shape, then click in the formula bar, then enter the “=Cell Address” (eg =A1) for the variable/formula in 1 to display.
    Step 5) Set the fill and outline of the shapes to blank
    Step 6) Enter the static text in the textbox, with spaces for each variable/formula.
    Step 7) Group the shapes and textboxes to give this some stability
    Options:
    For variables/formulas whose length changes:
    Instead of a textbox in step 2, use a shape.
    Have the text as a formula, and make the spaces in step 6 a function of the length.
    For blending with Excel:
    Expand a cell to the size of the textbox after step 6.
    Set the textbox border to none

User Tag List

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