Conditional formatting databar not showing % correctly

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


Not sure why I had to do this but set the values to-
and it is working correctly.

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.