conditional format for trendline

Hi,

Is there any way to apply conditional format on a trendlline and series name in xl 2003 or is there any alternative trick for that?

Depending on the condition and formatting you could use additional series or VBA coding.

Care to explain further? Maybe post a workbook to illustrate what you need.

Hi,

Please have a look at the attachment, click on the cells D2 and below to see the formula...
I'd like to change the trendline color based on the cell D1; if D1=1 then trendline is red,
if D1=2 then green... is that possible in Xl 2003 without using VB code?

create 2 new series
remove marker and line formatting
add trendline to each and colour accordingly

Thanks Andy, it's a nice solution ;-)