Im formatting a golf scorecard. What i need to do is highlight a cell where a score gets inputted if the player handicap is equal to or greater than the course handicap for that hole. If that makes sense. The numbers in red are the cells i want to highlight based on if the player handicap is higher or equal to the hole handicap.
For example
<tbody>
</tbody>
ex( John has a handicap of 4, on hole 1, the course handicap is 5, 4 < 5 thus it does not get highlighted for his score there. But on hole 2, the course handicap is 3, 4 is greater than 3, so it DOES get highlighted in the cell for his score on that hole.)
Any help is much appreciated Thanks!!!
For example
Hole Number: | 1 | 2 | 3 | 4 | 5 | 6 | 7 | ||
Hole Handicap | 5 | 3 | 1 | 7 | 1 | 9 | 5 | ||
Par | 2 | 2 | 4 | 4 | 6 | 5 | 3 | ||
Player handicap | |||||||||
Players: | Johnathan | 4 | 4 | 2 | 5 | 4 | 5 | 5 | 2 |
Bill | 7 | 4 | 3 | 4 | 6 | 7 | 4 | 4 | |
<tbody>
</tbody>
ex( John has a handicap of 4, on hole 1, the course handicap is 5, 4 < 5 thus it does not get highlighted for his score there. But on hole 2, the course handicap is 3, 4 is greater than 3, so it DOES get highlighted in the cell for his score on that hole.)
Any help is much appreciated Thanks!!!