Forum Discussion
How to keep the result of the formula from appearing down the column before a number is added
I wish to produce a Teams running score sheet for lawn bowls. When each team (rink) has finished their end the score for either the H or A team is entered. When the next end is finished again the s...
That can be handled either in cell formulas or by conditional formatting. The attached workbook* shows both techniques.
*...assuming I can get the forum to keep the attachment. Let's see.
Edit: The attachment was dropped, so see this file on OneDrive: 2026-03-30 LS sums only where data is present.xlsx