Conditional formatting font

[#1]

Hi All,

I'm using a text box in which I implemented a conditional formatting for the text color.I want to add conditional formatting to the style as well- add underline to the text.

Appreciate your help!

Thx,

Hila.

[Gysbert_Wassenaar]

That can't be done with a text box. Only the colors can be calculated conditionally. Well, maybe you could do something with a macro, but you're on your own there.

[#3]

Dear Hila,

Go to the Visual Cues in Chart properties,

Select the Expression or the Field,

Then define the condition,

then select the text color ,Style and under line.

then press apply and OK.

Ragrds,

Priyantha.

[#4]

Hi Priyantha,

I'm using a text box and not a chart...

But thanks for the effort

-Hila.

[flipside · Accepted solution]

Is it all the text you want to format, or just part of it, because Priyantha was onto something.

Please see attached.

flipside

EDIT: PS Ignore the bold and underline setting under Visual Cues, the magic is done in Expressions > Text Color & Text Format, but it is a chart.

[#6]

Nice one flipside! Very original thinking