Conditional Formatting with Graphs

I have a document that is a question and answer (an audit check sheet). Based on how the questions are answered, I need to have a bar within a graph change colour.

Is this possible ? Im not sure if we can use conditional formating or programming to amend a graph !!!!!

Would i need to use conditional formatting or vba/macro ?????

I have attached the document with a more detailed outline.

Cheers ..... A

Simplest way is to use multiple series. Set the overlap to 100.
Then use formula to determine which series displays the value for each point and the others all get set to NA()

There are many examples on the forum.