Re: Conditional Formatting in OOo Calc

Mark,

>>> A spreadsheet being used as a checklist.
>>>
>>> I want conditional formatting:
>>>
>>> If the cell contains 'pass' background it green.
...

> I can achieve what I need with
>
> Condition 1
> Cell value is | equal to | "pass"
> then Cell Style GREEN
...

> This is great, a shame you can't keep stacking conditions.

What do you mean by "stacking conditions"?

?condition formatting has a limit of three format choices
?condition being computed, eg pass/fail/null has a result set where n>3
?condition being computed has more than three clauses/more than two AND 
or OR conjunctions
?...

There may be a way...

-- 
Regards,
=dn

_______________________________________________
NZLUG mailing list [email protected]
http://www.linux.net.nz/cgi-bin/mailman/listinfo/nzlug