Calc: conditional formatting: use "less than" condition without formatting empty cells

I need to highlight all cells in a column with values of less than 15. However, I need empty cells to NOT be highlighted. Yet, with a simple use of the “less than” condition, all empty cell become highlighted too.

Help! :slight_smile:

You have two conditions, so you must declare both of them in condition format.

First condition “equal to “”” (double quotes is “empty string”) and style for it Default.

And next condition - as you already write - “less than 15”

Two conditions

Great, thank you. As I actually have multiple conditions (beyond the original), I discovered with your help that the order of conditions give the order of precedence and thereby the format applied. So that if there is a conflict with both condition 1 and condition 2 being applicable, the condition that was met first is the one that gets applied. Very helpful.