Re: Conditional Formatting in OOo Calc

On 27/10/2011 15:25, Mark Foster wrote:
> A simple requirement...
> 
> 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.
> 
> 
> I can do this in MS Excel in about 3 clicks.  OOo can't handle. Have
> tried various ways; it can't seem to accurate text-matching, and if I
> substitute numeric values (0 for fail, 1 for pass) it sees all blank
> cells as 0 (so items not yet checked show up as failures).
> 
> Interestingly if I create a .xls in MS Excel and then open it in OOo,
> the conditional formatting is preserved - until I click save in OOo. 
> Then by the time I reopen it in Excel the Conditional formatting is gone.
> 
> I'd much prefer to do this in OOo as the users of the spreadsheet will
> mainly be Linux clients with OOo installed. Google hits[1] imply that
> this is a known issue. and Official support is apparently lacking[2].
> 
> Any advice?
> 
> Cheers
> Mark.
> 

Not sure what version you are running but on the latest LibreOffice this
works for me. For matching text fields use double quotes. So:

 - select fields
 - Format > Conditional Formatting
 - Cond 1 ... cell value ... equal to ... "pass"
   - create new style and select a green background
 - Cond 2 ... cell value ... equal to ... "fail"
   - create new style and select a red background
 - Cond 3 ... cell value ... equal to ... <leave empty>
   - create new style and select an orange background



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