Change font size via formula

[Thomas_Schulz]

Hi all

Not sure if this has been solved already:
Is it possible to change font settings (e.g. I have a customer name) I want always to have in bold and other color. Right now, I am using conditional formatting via table settings, but can’t change the size of font

[Jean_Pierre_Traets]

Dear @Thomas_Schulz

@Paul_Danyliuk has posted something to underline, but in the same way you can make it bold / highlight and maybe also to change the color is possible.

This all is done with hidden formulas, so things could break at a certain moment in time

Highlight words in column based on master list of words

Here’s a solution that can match phrases. It’s a multi-step one though. Also it should be a more robust one than the one above, since it doesn’t split the text by every word but only wherever necessary to then stitch it back. It uses a hidden RegexExtract formula; it supports flags so instead of using Lower() elsewhere I just set it up to work as case-insensitive.

[Paul_Danyliuk]

Thanks @Jean_Pierre_Traets for summoning me

@Thomas_Schulz you can make yourself some pre-formatted templates and then insert text in them via a formula, e.g. Format():

Format() with style

Following the discovery of big buttons, I was tempted to see if something similar was possible with Format() — namely if one could supply a Big Cell formatted content as a template for the Format() function. Answer: YES! although a bit limited. [image] What is preserved when the text is pasted into the {1} {2} etc templates: Paragraph formatting: headers, lists, code blocks, text alignment etc What is NOT preserved: Span formatting: text color and highlight, bold/italic/etc. It gets ove…