Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

conditional formating take in account "no values"

Avatar

Community Advisor

26-09-2017

when creating a table you are able to "not show" cells with 0's by the col function "Interpret zero as no value"

1310538_pastedImage_0.png

if i use this, all cells with a "zero" do not have any value in this cell, thus no green bar shows up.

but if i use the function "conditional formatting", the cells with "interpret zero as no value" do get a color.

the following pictures show the effect - left with "no value" and right the same with "conditional formating"

pict1.pngpict2.png

idea: if cells are "no value" do not show the color!

1 Comment