Hi

I have a training record that contains %Compliancy in column D, the cells are conditionally formatted to be either red, orange or green based on a certain tolerance. I have then created a simple cluster column chart to show all the subjects and their compliancy.

Is it possible for each column in the chart to reflect the colour of the conditionally formatted cell (original data source)?

Thank you