how do I change cell background with formula

[hase22222]

I love smartsuite and don't want to use Excel, but I don't know how to change the background color of a cell depending on a formula.
If the value of the cell is positive the background should be green, if the value is negative it should be red.
In Excel I go to format -> conditioned formating, and there i can punch in my formula to change anything like background color or font etc.
I can't find the corresponding thing in 1-2-3
Please help.

 

[diogenes10]

This article:

http://www.pcpro.co.uk/shopper/pcpro-labs/64880/lotus-smartsuite-98.html

seems to indicate that you will have to look into LotusScript to accomplish that.

 

[danswindow]

You could also go to Lee's add-in page and get an add-in called setstyle. Here's the link to that page

http://www.geocities.com/lee_m2/addins.html

.

 

[hase22222]

Thanks for the links. Just downloaded the add-ins