Join us for the next Community Q&A Coffee Break on Tuesday April 23, 2024 with Eric Matisoff, Principal Evangelist, Analytics & Data Science, who will join us to discuss all the big news and announcements from Summit 2024!
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!
2 Comments
