Re: conditional chart formatting: specific colors

This traffic light chart is based on a bubble chart

The colour displayed is based upon cell formula.

The download includes the example also another version of a single stop based around a pie chart. There is explanation in the workbook.