Ask Your Question

How to conditionally format a color to all empty cells

asked 2019-09-15 07:31:17 +0200

Andreasd gravatar image

How do I set conditionally formatting to set a background color for all empty cells? I found the ISBLANK formula but I don't know how to set it up

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-09-15 08:41:08 +0200

ebot gravatar image

updated 2019-09-15 09:14:08 +0200

Calc has a built-in Conditional Formatting feature. Mark the desired area. From the menu, choose Format>Conditional Formatting>Condition .... Empty cells are determined with <""> (without the tip bracket).

image description

image description

Sorry, for the German UI.

Here the description to "conditional formatting".

If my answer has solved your problem, please click on the checkmark in the circle image description to the left of the answer and click on the arrow ^ for upvote. This will tell the community that the question has been answered correctly.


With "Apply template" you can create a new template. You can e.g. set the color and the border.

image description

edit flag offensive delete link more


With me Windows 10 Home; Version 1903; 64-Bit | LibreOffice, Version: (x64).

ebot gravatar imageebot ( 2019-09-15 08:41:57 +0200 )edit

Thanks! That worked! Any way to keep the grid?

Andreasd gravatar imageAndreasd ( 2019-09-15 08:46:04 +0200 )edit

See my edited answer.

ebot gravatar imageebot ( 2019-09-15 09:14:33 +0200 )edit

This doesn't work when moving something. The cell I move from get stuck on white and does not change to gray even if it's empty

Andreasd gravatar imageAndreasd ( 2019-09-20 11:31:06 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-09-15 07:31:17 +0200

Seen: 26 times

Last updated: Sep 15