Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

conditional formating take in account "no values"

Avatar

Avatar
Coach
Community Advisor
Urs_Boller
Community Advisor

Likes

532 likes

Total Posts

1,024 posts

Correct reply

257 solutions
Top badges earned
Coach
Bedrock
Contributor 2
Originator
View profile

Avatar
Coach
Community Advisor
Urs_Boller
Community Advisor

Likes

532 likes

Total Posts

1,024 posts

Correct reply

257 solutions
Top badges earned
Coach
Bedrock
Contributor 2
Originator
View profile
Urs_Boller
Community Advisor

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

Avatar

Avatar
Give Back 1000
Level 10
jantzen_belliston-Adobe
Level 10

Likes

363 likes

Total Posts

2,371 posts

Correct reply

823 solutions
Top badges earned
Give Back 1000
Give back 900
Give Back 800
Give Back 700
Give back 600
View profile

Avatar
Give Back 1000
Level 10
jantzen_belliston-Adobe
Level 10

Likes

363 likes

Total Posts

2,371 posts

Correct reply

823 solutions
Top badges earned
Give Back 1000
Give back 900
Give Back 800
Give Back 700
Give back 600
View profile
jantzen_belliston-Adobe
Level 10

27-10-2020

 
Status changed to: Archived