Conditional Formatting in OOo Calc

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.

[1] http://openoffice.blogs.com/openoffice/2007/01/conditional_for.html
[2]
http://wiki.services.openoffice.org/wiki/Documentation/FAQ/Calc/Formatting/How_can_I_use_conditional_formatting%3F
shows the howto as 'to be written'.


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