Re: Conditional Formatting in OOo Calc

On 27/10/11 15:51, yuri wrote:
> On 27 October 2011 15:25, Mark Foster wrote:
>> A spreadsheet being used as a checklist.
>>
>> I want conditional formatting:
>>
>> If the cell contains 'pass' background it green.
>> If the cell contains 'fail' background it black.
>> If the cell doesn't contain anything, background it orange.
> OpenOffice is deprecated.
> The current suite is now called LibreOffice.
>
> http://help.libreoffice.org/Calc/Applying_Conditional_Formatting
>
> BTW I tried it in OOo 3.2.0 and it works for me.
> Remember to put "pass", "fail" and "" inside double quotes in the dialogue box.
>
>

Thanks Yuri.
The Doublequotes appears to be the key.
I can achieve what I need with

Condition 1
Cell value is | equal to | "pass"
then Cell Style GREEN

Condition 2
Cell value is | equal to | "fail"
then Cell Style RED

Condition 3
Cell value is | equal to | ""
then Cell Style UNCHECKED

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

Btw your statement is misleading - OOo is not  'Deprecated'. LibreOffice
is a fork of OpenOffice but OOo appears to be active, as an incubator
project of the Apache Foundation.    Aside from that, OOo ships with my
Ubuntu distro (10.10), LibreOffice does not.  I expect whether
LibreOffice or OpenOffice are readily available is a distro-level
choice.  I'm using what is infront of me, I expect my colleagues who'll
be using this Spreadsheet will use a mix of OOo and LibreOffice
depending on the platform they're using.

Thanks for the pointer.

Cheers
Mark.



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