Different colors for databar

Hey there!

Does an option exist that can turn the databar different colors for certain ranges?

i.e. can the bars turn from green (100% to 75%) through yellow (>75%; ≤50%) to red (>50%) ?

I could not find a solution. If you use color bars / color scale (3 entries), you can work with 3 colors. But then you have no bar anymore. An alternative would be a duplication with different “conditional formatting”. Maybe this can help you? I wish you success.

Sorry for the German-UI.

Here you will find further information about “Conditional Formatting”.

And here is a guide in English.

If my answer did solve your problem, please click the big checkmark inside the circle to the left of this answer.
It then indicates to the other participants that the question has been answered correctly.