Change Expression Text Color Based on Value.

[bnelson111]

Everyone,

I have an interesting challenge which maybe simple but has be beaten. Aim is to change the color of the number based on the value from the expression which is in a Text Box.

Expression below:

', Slit Mtrs '&(num(sum({<

PSADATA.processtype={"*slt*"},

PSADATA.Description={"*ASH*"}>} PSADATA.quantity)  ,'#,##0'))

Basically if above value comes back over 2000 then I wish it to be displayed in RED. So below 119,177 should be red not black and below is a text box made with expressions.

[sinanozdemir]

I don't think you can change the color of a partial text in a text box. Although, you can layer another text box just for the numbers and change the color of that text box.

[roger_stone]

Use two text boxes and make each conditional on the value.

As Sinan says, you can't change part of the colour in a text box.

[ganeshreddy]

This may helps you.

TExt BOx Value Color change

Change Expression Text Color Based on Value.

Regards,

Ganesh

[settu_periasamy · Accepted solution]

Hi,

May be Based on Calculated Condition Font Color Based on Condition?

Check the Attachment.

[bnelson111]

Thanks.