RedditPP Mascot

RedditPP

r/googlesheets • … • u/Caitrix

How can I format (bold, italic) certain words in a cell, even when its content is the result of a formula?

I know I can format cells, to contain multiple fonts and sized, bold words and so on. For example \[*This* is 1 **test**\]. But when I write this not as plane text, but as a result of a formula, for example \[="This is "&1&" test"\] (which correctly results in \[This is 1 test\]), I can not individually italic or bold the words "this" and "test".

How can I achieve the same result when writing as a formula, as when writing it as plane text?

\[edit\] Seems like there aren't really options to give me the desired result. I didn't try adding any scripts though, as I want to keep it simple (and I don't know javascript). Maybe there will be an update in the future, that adds the option for text formating in functions/formulas.

— 0