conditional formating take in account "no values"

ursboller

MVP

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!

Comment