conditional formating take in account "no values"

Avatar

Avatar

ursboller

MVP

Total Posts

1.0K

Likes

484

Correct Answer

250

Avatar

ursboller

MVP

Total Posts

1.0K

Likes

484

Correct Answer

250
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!

1 Comment (1 New)
1 Comment

Avatar

Avatar

jantzen_belliston-Adobe

Community Manager

Total Posts

1.9K

Likes

312

Correct Answer

570

Avatar

jantzen_belliston-Adobe

Community Manager

Total Posts

1.9K

Likes

312

Correct Answer

570
jantzen_belliston-Adobe
Community Manager

27-10-2020

 
Status changed to: Archived