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?
Bookmarks