how can i achieve Conditional formatting for a clusterd column chart

[Tarunika]

hi , 

I have a requirement where the colour of the bars in a clustered column chart should be changed based on the percentage i.e if >95% than green ,75%-94% than orange,50%-70%than yellow and less than 50% red.Please can anyone help me in achieving this 

Regards,

Tarunika P

[DoubleJ · Accepted solution]

In formatting pane go to "Columns - Colors" and click "conditional formatting":

Set the rules:

Hope this helps
JJ