OpenOffice how to add more than 3 conditional formatting?

Question

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

If this hasn't been asked there already, I'd suggest deleting this question and asking it over on [su], though consider adding more details in order to clarify the question more precisely (if necessary). — David Thomas, Jun 03 '18 at 18:42

score 2 · Accepted Answer · answered Jun 04 '18 at 18:29

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

And here is the dialog for LO:

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

1 Answers1