I need to format the CHART AREA COLOR based on a condition. If the data is
higher than a certain amount I need the CHART AREA to be RED.

I do not know VBA too well so please give me as much detail as possable.

Justin