Forum Discussion
golf league formula to calculate and flag age
Thank you.
Let's say you have the ages in E2 and down, and scores elsewhere in row 2 and down.
Select the range with the scores.
The active cell in the selection should be in the top row of the range, in this example in row 2.
On the home tab of the ribbon, select Conditional Formatting > New Rule...
Select 'Format only cells that contain'.
Leave the first drop down set to 'Cell Value'.
Select 'less than' from the second drop down.
In the box next to it, enter the formula =$E2
Remember, E is the column with the ages and 2 is the row of the active cell.
Click Format...
Activate the Font tab.
Select a font color, and perhaps other settings such as Bold.
Click OK, then click OK again.
Let's say you enter date of birth in D2 and down. The formula for the age could be
=IF(D2="","",DATEDIF(D2,TODAY(),"Y"))
- Thank you! That helped.
What exactly do you mean by "flagging"? (Please keep in mind that I know nothing about golf)
- By flagging I mean, some type of a notification that the player scored under his age for that round of golf.
My thought was, as the scores are entered into the cell it would change color to flag the score is less than his age. This may not necessarily how best to 'flag' the score to age, but some notification, please.
We have about 60 seniors playing so comparing each score each week to the player's age would be time consuming.
