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"


Community Advisor


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


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"


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

1 Comment