How to specify "else" condition in conditional formatting?

Hi,

I use LibreOffice 6.1.2 on Windows 7. In Calc I have large table with multiple columns. But on one column I would like to conditionally format the colors.

Simplified sample data:

City
Rome
Paris
London
Berlin
Madrid
(hundreds of other)

Now I would like to mark with green cells which contains cities: Rome, Paris and London and all remaining cities red (there is huge list of “red” cities, so I can’t write conditional rule for each one).

I did:

  1. Mark City column.

  2. Format | Conditional | Condition.

  3. I have set:

    Condition 1: “Cell values is” “equal to” “Rome” Apply Style: Good.

    Condition 2: “Cell values is” “equal to” “Paris” Apply Style: Good.

    Condition 3: “Cell values is” “equal to” “London” Apply Style: Good.

    Question: Now how do define?
    Condition 4: All remaining cells Apply Style: Bad

Thanks

Just apply the “Bad” style by default, without conditional formatting? or just use something like “not blank” as the last item (conditions are evaluated in order, until one matches)?

Thanks a lot. I see I can define “red” color background for whole column and then specify “conditional formatting” only for green cells: Rome, Paris and London. Conditional formatting only overrides formatting for cells that matches the conditional and leaves all other cells (red in my case) untouched.

Thanks very elegant solution.

Excellent answer and the simplest way to proceed.