Google Spreadsheet, BOLD font weight using cell formula

Question

I use Google Spreadsheet to do some calculations.

At the bottom of the table I need SUM, AVG and some others, and everything is in order.

But I made a long cell with all the text, for example:

="Hi at all, this is my report: "&SUM(B:B)&" are the sum of my fingers, "&AVG(C:C)&" is the avg of my sons." 

etc.

Everything works. But I need to make a bold SUM(B:B) .

I will not use individual cells for mathematical results.

I tried with ....<b>"&SUM(B:B)&"</b>.... but obviously I accept <b></b> in my cell, not the bold font .

How to style from a formula in a cell?

Answer 1

At this time, you cannot highlight partial components of any formula in Google Sheets. The solution mentioned with the “B” icon or in bold only works if the desired bold selection is a whole cell containing a formula or a partial cell that does not contain a formula.

Answer 2

To bold what is in the cell, just select the cell, then press the B button on the font toolbar at the top of the google sheets