conditional formating take in account "no values"

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!