conditional formating of chart elements

[MartyZ]

Hi together,

I tried to find solution in older posts but without success.
I have simple question. Is it possible to change color of points (values) and lines between points in normal chart automaticaly?
It means - I have tolerance - for example 100. And every point over 100 is green, every under 100 is red. And lines between points are green for increasing between points and red for decreasing between points...

Any idea if it's possible.

Thank You very much for eventual tip

Nice Excel day to you all

MartyZ

[Andy Pope]

You can use additional series with data based on formula to do the data points.
The line colour would require vba code.