Forum Discussion
How to Bold Amount in text formula in excel & Subtotal in Table
I am facing the issue regarding Bold text in formula's & Subtotal in Table
the example file link is on one drive. due to issue of attaching in this dialog box.
https://onedrive.live.com/edit.aspx?cid=fff473577f7df103&page=view&resid=FFF473577F7DF103!29551&parId=FFF473577F7DF103!941&app=Excel
10 Replies
- Is it possible to insert photos?
The file from OneDrive is probably not downloaded by many for security reasons. The risk of malware is too great.
If photos are possible, please provide a more detailed description of the problem.
At the end I would like to point out that knowing the Excel version and the operating system is of great advantage in order to be able to submit a quick and more precise solution proposal.
Thank you for your patience and understandingsorry jpg is also not attached
so i update it mediafire link
https://www.mediafire.com/file/du2lkgp1x91a0cp/sample+file.xlsx/file
As far as I know (even if that doesn't mean much 🙂 in formula you can't format parts differently.
But you can do it with VBA code.1. Start the macro recorder
2. In a cell, select only the text that should be bold
3. set the bold attribute for the selected text
4. Press the Enter key to complete this process
5. quit the macro recorder
Now you have recorded the VBA code and can adapt it in the VBA editor....Or split it into several cells and format the relevant content accordingly.
Insert subtotals in a list of data in a worksheet
Hope I was able to help you with this info.
NikolinoDE
I know I don't know anything (Socrates)
