Ask Your Question

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

asked 2015-02-06 20:42:43 +0200

yayalala gravatar image

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! :)

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2015-02-06 21:13:45 +0200

JohnSUN gravatar image

updated 2015-02-06 21:19:10 +0200

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

edit flag offensive delete link more


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.

yayalala gravatar imageyayalala ( 2015-02-06 23:47:27 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2015-02-06 20:42:43 +0200

Seen: 2,740 times

Last updated: Feb 06 '15