Conditional formulas for bar ONLY when 2 curve are crossing

[Rachidlea]

Hello All,

I would need your support on the attached excel. from the attached example, you can see 3 types of curves [Blue, Red and Yellow]. the plan is to have a kind of alarm using the BAR in grey only when the blue line and yellow line are crossing.

is this something we can setup easily or any advise ?

thank you in advance

R.Book3.xlsx

[Kaper]

I added a column J formula (could be used directly in formula 2, but this way it's better visible) checking if lines are crossing:

Please Login or Register  to view this content.

and then modified formula (2) in column H (you probably need to replace semicolons with commas):

Please Login or Register  to view this content.

See the result in the file

[Rachidlea]

Hello Kaper,

thank you very much.

just need one more support please. have reduced the channel [yellow curve] and have noticed even if the blue curve is not crossing at some point but still have the bar.

will be grateful if you can have a look. attached the new updated one

Thank again
RBook_Rev1.xlsx