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:
-
Mark City column.
-
Format | Conditional | Condition.
-
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