Hi,
I'm using Excel 2003, and trying to come up with a way to efficiently apply conditional formatting to different parts on 1 data series in a line chart. I want the line to be green when it's above my set point, and to be red when it's below it. Anyone know how to do this best?