Forum Discussion

Jalil1985's avatar
Jalil1985
Copper Contributor
Dec 28, 2021

How to Bold Amount in text formula in excel & Subtotal in Table

Hi All

Spoiler
Spoiler
 

 

I am facing the issue regarding Bold text in formula's & Subtotal in Table 

 the example file is attached.

 

http://Desktop\sample file.xlsx 

Spoiler
Spoiler
 

 

7 Replies

  • NikolinoDE's avatar
    NikolinoDE
    Platinum Contributor

    Jalil1985 

    As Mr. Baklan has already informed you, a file (without sensitive data) would be appropriate in this case.

    At the same time, information about the Excel version and the operating system would be of great advantage for everyone and especially for you.

    Here is a link with more information about it:  Welcome to your Excel discussion space!

     

    Nevertheless, here is a quick solution proposal with VBA code (with reservation, as there is no information about the version, operating system, etc.):

     

     

    Sub Bold()
    ' example like this
    ActiveCell.Value = "Excel is great!"
    ActiveCell.Font.Bold = True
    'or so
    Range("A2").Value = "Excel is great!"
    Range("A2").Font.Bold = True
    End Sub

     

     

     

    You could also do it with conditional formatting.

    Click on the link for an example.

     

    Thank you for your understanding and patience

    ...and hope I was able to help you with this info.

    Nikolino

    I know I don't know anything (Socrates)

     

Resources