How to change color for all data points based upon a rule?

[#1]

Hi Experts,

           I tried to change colors for the data points meeting a rule - three of four continuous points on one line are higher than those on another line. Right now the color was only changed on the first data point. Not sure why. Please refer to the file in the attachment.

Thanks

Longmatch

[Anonymous]

as the graph you okay, really this just changing color if 3 of the 4 points are higher. But the expression is evaluated points from right to left. to evaluate from left to right should be BEFORE the function.

Try putting
if (rangesum (below (if (% Data>% R, 1, 0), 0,4))> = 2, Black (), Yellow ())

The expression is fine.

[#3]

Check this blog. Hope this helps you to solve.

[#4]

Tried your solution, no luck. There is still one data point colored in black.