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.
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.
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.
- That will work after I link the calculated age from the Master List workbook to an empty cell in the Weekly Scores workbook.
Danke Schoen!