Forum Discussion
Jalil1985
Dec 28, 2021Copper Contributor
How to Bold Amount in text formula in excel & Subtotal in Table
Hi All [ 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 ]
NikolinoDE
Jan 03, 2022Platinum Contributor
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.
I know I don't know anything (Socrates)