Visual Cue for a Text Object

[evansabres]

Is it possible to have a text object (with a numerical value) have a visual cue? For example, if the number is less than 0 be red, greater than 0 be green. I know how to do this in a chart, but wondering if it is possible in a text object?

[sunny_talwar · Accepted solution]

You should be able to do this...

[evansabres]

This is my expression:

=IF(NUM(SUM(transQUANTITY),'#,###.')-num(sum(projectedSales+projCOMP),'#,###.') >0, Green(), Red())

When I try to enter your equation, I get an output of RGB(128,0,0)

[evansabres]

I see where I made a mistake. This works, thank you.

[sunny_talwar]

What value does this give you in a text box object?

Sum(TransQUANTITY) - Sum(projectedSales + projCOMP)