Conditional Series Collection Colour for Chart

Hi there,

I am using a bar graph and would like conditional formatting for a series collection. So if the series collection is greater than 30%, the single entry (not the whole series) would turn red. I have attached an image of what I currently have. There is a data validation list at the top which tells the graph what series to use, so the data is always changing.

I hope this all makes sense. Basically, if an entry is above 30%, I want the single entry in the series to turn red.

Cheers,

Benno

Conditional charts can be made by using additional series.
http://peltiertech.com/Excel/Charts/...nalChart1.html

This recent post does it with and without code
http://www.excelforum.com/excel-char...in-charts.html