Linear gauge conditional formatting more than 100%

893 views#conditional formatting linear gauge


I want to display a production progress via the linear gauge.

It works fine, but I have an issue with the conditional formatting.

Sometimes, the production produces more than 100 % of the target.

I am not able to set the interval from 100% to 110% in red. It is not possible to select a number over 100%.

Do you have any ideas or workarounds?

Thanks for your help!

Asked question