I have attached a picture to try an explain what I need to do.

I would like to put a line between the negative a positive values to indicate the breakeven point.

I would this line to apply to the whole column. The table is 30 rows.

I understand that I can use conditional formatting to apply the line but I cannot figure out how to write the statement.

I want to say: =IF(AND(M1<0,N1>0)) then put a line to the left of N to show the breakeven (I know I will do this with borders no problem and there seconf and 3rd Logic is missing in the forumlae)

Am I complicating the issue or have I missed something completely? The statement needs to be applied from B1 to P1 as the value will breakeven at different points.

Thanks