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!