Sign in to Community
Sign in to view all badges
Expand my Community achievements bar.
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!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.