openoffice-basic

OpenOffice how to add more than 3 conditional formatting?

How to add more than 3 conditional formatting in OpenOffice ?

By defaut it's 3, but i want add more, how can I do it ?

For this moment I have 3, like this:

$H21="OPEN"

$H21="CLOSED"

$H21="SEND

But a want to add another 2 conditions like:

$H21="WAITING"

$H21="DELETED"

Thanks

Solution

  • Upgrade to LibreOffice, which allows an unlimited number. Here is the dialog for AOO:

    only 3 conditions

    And here is the dialog for LO:

    unlimited conditions

    If sticking with OpenOffice is a requirement, then you could write a macro. See the question here, which shows a macro for 4 conditions.