Hi

Can anyone help with this problem.

I have put together a prepaid expenses schedule that calculates the prepaid values across the year. When the prepayment is fully used, the next cell shows the text "Delete Line" and is highlighted using conditional formatting. If I copy the formula beyond this point it still shows "Delete Line" in all of the following cells. Is it possible to to show this message only the once and leave all copied cells to the right as blank cells.

Many thanks



TabH