Conditional formatting on bar chart for each bar? Is this possible?

Hi,

I am trying to create a type of bar chart, where each bar may be coloured depending on conditions and the measures I've created S1, S2, S3, S4.

Below is an example of the bar chart.

I would like to do this:

1. The bar "Below" will be red if S1 is a certain number

2. The bar "Marginal" will be yellow if S2 is a certain number

3. The bar "Meets" will be orange if S3 is a certain number

4. The bar "Exceeds" will be green if S4 is a certain number

Is there a way to do this in one graph? Through some research I've found I can do conditional formatting for all of the bars for the same measure, but not different measures...

I would appreciate any guidance on this.