I need a formula that combines two 'Text Format Functions' in one simple formula.

Here is a simplified example.

(One Table) Three fields: Priority(text), Title Entry(text), Title Result(calculated)

So what I need is: The title to turn Red & Bold when the priority is 'HOT'.

A formula or custom function that will turn the text in a field both Red and Bold at the same time, if certain conditions are true in another field.

I have not been able to figure it out. Seems pretty simple, so I am ready to feel foolish.

All you have to di nest one function inside the other like this:

TextColor(TextStyleAdd(field1; Bold); RGB(255; 0; 0))

Thank you very much.

I was on the right path, but close doesn't quite work.