How do I show a number that is negative to be Red in Table Box Properties?

[jrideqlik]

I have several Fields of amounts in a Table Box that I need to show as red if they are negative <0 . Any suggestions?

[stevejoyce · Accepted solution]

Table box does not have this option.  Even custom format cell is based on the entire expression, not row level.

I would use a Straight Table and you can then put expressions for your background color.

[jrideqlik]

Your right the Table Box does not have this option. I was just looking for a workaround without using a straight table. Thanks for your reply Steve!