Adding Colors in a Text box

[tmumaw]

I have a text box with this calculation in it.  I want the number to appear in Red if negative and Green if positive.  The statement says it's formatted okay, but colors do not change.  What am I missing.

Thanks

=num(if(count({<FISYR = {$(=$(vFisYr) - 1)}, YR_SW = {1}, Acq_Sales = {1}>} Distinct([Sold To])) - count({<FISYR = {$(=$(vFisYr) - 5)}, YR_SW = {1}, Acq_Sales = {1}>} Distinct([Sold To]))) /
count({<FISYR = {$(=$(vFisYr) - 5)}, YR_SW = {1}, Acq_Sales = {1}>} Distinct([Sold To])) < 0,RGB(255,0,0),RGB(0,153,0),'###.#%')

[jwjackso · Accepted solution]

Is this section if(count({<FISYR = {$(=$(vFisYr) - 1)}, YR_SW = {1}, Acq_Sales = {1}>} Distinct([Sold To])) - count({<FISYR = {$(=$(vFisYr) - 5)}, YR_SW = {1}, Acq_Sales = {1}>} Distinct([Sold To]))) /
count({<FISYR = {$(=$(vFisYr) - 5)}, YR_SW = {1}, Acq_Sales = {1}>} Distinct([Sold To])) < 0,RGB(255,0,0),RGB(0,153,0))

in the textbox->font->color->calculated expression?