TExt BOx Value Color change

[abhaysingh]

hi All,

i have target in one text box and in other actual, i want when my target > Actual it should show red color else green color

[Anonymous]

On the Font tab of the Text Box :

• <Click> Color
• <Click>  Calculated
• Enter expression
  • if ( target > Actual , Red(), Green() )

[sunny_talwar]

It seems you have two text boxes? Do you want both turn Red or Green at the same time or Do you want only Target to turn Red when Target > Actual and only Actual to turn green when Actual > Target?

[sunny_talwar]

If condition might change, but the procedure will remain the same as listed by Bill Markham‌. The same procedure looking at a image is as follows:

I hope this will help.

Best,

Sunny

[abhaysingh]

yes i have two target i want actuals to turn red or green when target> actual

[sunny_talwar]

Have a look at the attached document. It is green when nothing is selected because Sum(Actual) > Sum(Target)

But as soon as you select A, the text box turns Red:

See the steps I used:

I hope this will clarify you the process.

Best,

Sunny