Conditional formatting

**scottb** · 01-13-2010, 05:20 PM

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

**zbor** · 01-13-2010, 05:23 PM

No picture... and if you don't have sensitive data rather upload example (or change names)

**scottb** · 01-13-2010, 05:29 PM

Really sorry! did not attached as you mention.

**zbor** · 01-13-2010, 05:37 PM

Here, try this in first cell:

Conditional formatting -> New rule -> Use formula to determine wich cells to format -> =SIGN(A1*B1)<0

Choose formatting (right line)

**scottb** · 01-13-2010, 05:53 PM

Works a treat. Applied it across the range from B1:P1.

However, this row is number 10 in a table of 30. How do I apply the line to the entire column, so that you can see a clear line break in the table?

Thanks