Copy of the code can be found here: https://www.bluepecantraining.com/conditional-formatting-chart-vba-macro/
This video details the VBA code needed to conditionally format a chart. The scenario is sales vs target: each column that represents a value that has met the sales target is coloured blue, otherwise red. The VBA code is stored in the sheet object and runs on the change event.
------------------------