how to color empty cells?

[#1]

Good Day,

how do I color empty cells in a table dynamically?

Example: yellow coloring null fields.

I thank you!

[Clever_Anjos]

Expand your expression e look for Background Color

=if(IsNull(yourfield or expression),Yellow())

[#3]

Hi,

In the expressions tab, double click on your expression

You will see several items, one of them is Background color : enter a definition (an expression) to color the cell

sth like ; if my expression is null then yellow

Fabrice

[MayilVahanan]

Hi

Try like this

Expression -> Background color

=If(IsNull(Expression) , Yellow(), Green())

// Here expression represents something like sum(sales)

[Gysbert_Wassenaar · Accepted solution]

In a pivot table or straigth table chart you can do it like this:

Enable the grid and right click a cell and use Custom Format Cell to set the default background to yellow.

Next, open the charts properties window, go to the expressions tab and click on the + sign in front of the expression. Select background color and enter white() as expression.

That will give cells with a value a white background color while the other cells will have a yellow background. See attached example.