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?![]()
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?![]()
Last edited by Ralem; 06-09-2010 at 09:18 AM.
Cheers
Ralem
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 ;-)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks