Hi,

This example demonstrates how to change the line above and below a datum.
http://www.andypope.info/charts/conditionalline.htm

It gets more complex if you do not want the datum line, which is masking the
fact that the other 2 lines are still continuous.
Without the datum you will need to include empty points in the addition
series to cause the lines to have gaps.

You might find this approach more manageable, which is to highlight the
specific points along the line rather than a segment of the line.
http://peltiertech.com/Excel/Charts/FormatMinMax.html

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"andy" wrote in message
...
Is it possible to change the line width (or color) based on a if-then
statment?
For example: if the value of one line if hitting new lows for the day but
the value of another line is not hitting new lows for the day is it
possible
to change the width or color of the first line because this condiition is
false?
Thanks!