Does this illustrate what you want?...
Suppose you have data in column A, in the range A3:A8. In the range B3:B100
you have the running total for column A. (Cell B8, for example, has the
formula =B7+A8.) But no subtotals show above or below cell B8. Then, when
you enter a value in cell A9, the subtotal appears only for cell B9.
If that's what you want, here's how to do it:
Select the range B3:B100. Make sure that cell B3 is the active cell. Choose
Format, Conditional Formatting. For Condition 1, choose Formula Is in the
list box. In the single text box, enter this formula:
=OR(B3="",B4<>"")
Choose Format... In the Font tab, specify a white font. Then choose OK
twice.
With luck, all the results in column B will disappear except cell B8, which
is the subtotal for the last-entered value in cell A8.
Charley Kyd
ExcelUser.com