Hiding results

[Guest]

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]

=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.

 

[Guest]

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

 

[Guest]

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