Re: Conditional Formatting in OOo Calc

Mark Foster <[email protected]> Fri, 28 Oct 2011 10:17:32 +1300

Newsgroups	gmane.org.user-groups.linux.new-zealand.general
Message-ID	<[email protected]>

On 28/10/11 09:33, David L Neil wrote:
>
>> 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...
>

Oh i'm sure there is, but the UI is less than intuitive if that's the case.

Say I want to have different colours for the words 'yes, no, maybe,
other'.  That's 4 sets of conditions.


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