At 16:05 21/11/2007 -0500, Henning von Roeder wrote:
I am trying to conditional format a cell in Calc. In excel, for
instance I can format a cell to show a function result, if it is
greater than 0 only. It goes something like this
IF(SUM(A1+B1)<=0;" ";SUM(A1+B1))
I tried this in Calc, but it just shows the formula, nothing else.
Yes I unchecked the "Show Formula Option in ->Tools->Options"
Anybody got an Idea.I run Open Office under Ubuntu 7.10 Gutsy, and W2K Serv. 4
If you have done exactly as you say, putting this formula into the
cell (not what Calc calls "Conditional Formatting", in fact), then
all that is missing is the equals sign that must start every formula: =IF( etc.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
