I have created a spreadsheet that I fill out daily. Some of the formulae take
information from the row above i.e. in cell E15 the formula is =E14-J14+P14.
This creates the same answer all the way down the column until I enter the
next days stats. Is there any way of hiding the results in the rows beneath
the one you are working on ?

=if(count(e14,j14,p14)<3,"",e14-j14+p14)

Will make the cell look empty until you have 3 numbers in E14, J14, and P14.

Parkingmang wrote:

I have created a spreadsheet that I fill out daily. Some of the formulae take
information from the row above i.e. in cell E15 the formula is =E14-J14+P14.
This creates the same answer all the way down the column until I enter the
next days stats. Is there any way of hiding the results in the rows beneath
the one you are working on ?

--

Dave Peterson

This likely will meet with criticism, but this worked for me.
Paste this into the Sheet module your working in.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Range("E:E").Font.ColorIndex = xlAutomatic
Range(Target.Offset(1), Target.Offset.End(xlDown)).Font.ColorIndex = 2
End Sub





"Parkingmang" wrote:

I have created a spreadsheet that I fill out daily. Some of the formulae take
information from the row above i.e. in cell E15 the formula is =E14-J14+P14.
This creates the same answer all the way down the column until I enter the
next days stats. Is there any way of hiding the results in the rows beneath
the one you are working on ?

Wooooow;
Forget my TRY, it is a disaster; I'm going to keep trying though.

"Parkingmang" wrote:

I have created a spreadsheet that I fill out daily. Some of the formulae take
information from the row above i.e. in cell E15 the formula is =E14-J14+P14.
This creates the same answer all the way down the column until I enter the
next days stats. Is there any way of hiding the results in the rows beneath
the one you are working on ?