Change colour of bar if condition is met

[DeeBee]

Good day to all,

I hope you guys can help me?

I have data that contains an activity & duration. I want to display the duration as a value in a stacked chart per activity, but when the acivity is completed the color should change to green and to red when there's a problem. All the other incomplete activities should still remain in their different colours. So, eventually I'll have one long green bar chart with only borders to differentiate between the activities if all is completed and all problems are sorted. I hope I've explained well enough. I'm attaching a sample of the data.

Please?

God Bless