Question changing colors of cell background on certain conditions

I have a table with 10 columns.  One column has a value this is either positive or negative.  When that particular cell is negative I want it have a background color of #EEEEEE and when it is positive I want it to have a background color of #ABD66F.

This is stumping me.  Any help is appreciated.  Thanks.

Shawn,
Take a careful look at this thread
http://www.tinybutstrong.com/forum.php?msg_id=9090#

It looks like it can be adapted to your needs - if you can't get that approach to work come back for more.

Thanks.  I have it working now, but did something a little different than what the posts mentions.  Thanks though.


Now my next question:  I have two fields that need subtracted from each other, can I do this with TBS.

Example:

price=2.00
rebate=1.00

[b1.price]-[b1.rebate] is what I'm trying to achieve.

Any ideas?

Take a look at the "Plus" plugin
http://www.tinybutstrong.com/plugins/plus/doc/manual.html