Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good Day,
how do I color empty cells in a table dynamically?
Example: yellow coloring null fields.
I thank you!
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.
Expand your expression e look for Background Color
=if(IsNull(yourfield or expression),Yellow())
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
Hi
Try like this
Expression -> Background color
=If(IsNull(Expression) , Yellow(), Green())
// Here expression represents something like sum(sales)
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.