Ask Your Question

Conditional formatting databar not showing % correctly.

asked 2017-06-04 18:45:15 +0200

estes53 gravatar image

updated 2017-06-04 18:49:49 +0200

A cell that should have a 50% bar has one that is closer to 70%. What might I be doing wrong?


edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2017-06-04 21:44:13 +0200

estes53 gravatar image

Not sure why I had to do this but set the values to- Min,Formula=0 Max,Formula=1 and it is working correctly.

edit flag offensive delete link more


When you don't specify min and max, the values in the range are analyzed to calculate min and max, and min gets 0%, max gets 100%. The numbers aren't treated as percents themselves; it doesn't matter that you have formatted them to be shown as percents - for LO they are just some numbers. So, without explicit limits definition, you may get "strange" results.

Mike Kaganski gravatar imageMike Kaganski ( 2017-06-04 22:50:01 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-06-04 18:45:15 +0200

Seen: 95 times

Last updated: Jun 04 '17