Hello

I have two columns. Column A has 'From' values, and column B has 'To'
values. These froms and tos are distance intervals. The intervals may or
may not be continuous from row to row. I have constructed a formula that
would draw a line inbetween rows which have a break in interval measurements.

=$C2<$B3

This works fine. However, once in a while there is a blank row. These
blank rows must be there, I can't take them out. I need to tell Excel that,
in the event that the next row is blank, to ignore it and take the value in
the following row (for inserting into the formula to determine if a line
needs to be drawn).

I don't know how to append this condition on my formula. Any ideas?