Highlight cells based on if a cell if less than another

[chaz8900]

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
[TABLE="width: 600"]
<tbody>[TR]
[TD]Hole Number:[/TD]
[TD][/TD]
[TD][/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]6[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]Hole Handicap[/TD]
[TD][/TD]
[TD][/TD]
[TD]5[/TD]
[TD]3[/TD]
[TD]1[/TD]
[TD]7[/TD]
[TD]1[/TD]
[TD]9[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]Par[/TD]
[TD][/TD]
[TD][/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD]6[/TD]
[TD]5[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Player handicap[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Players:[/TD]
[TD]Johnathan[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD]2[/TD]
[TD]5[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]5[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Bill[/TD]
[TD]7[/TD]
[TD]4[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]6[/TD]
[TD]7[/TD]
[TD]4[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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!!!

 

[jerbaldw]

I need a little bit more information. How many golfers will you use this for? What version of excel are you using?

If its a small amount of golfers, you can use conditional formatting to change the text color. Instructions found here: How to Apply Conditional Formatting in Excel: 16 Steps


If your doing a large tournament I would suggest a VBA solution. I can help, but I need to know your worksheet format. You can PM me. Thanks.

 

[etaf]

goto the cell with the first score in and use a conditional format

=D$3<=$C6

for 2007 or 2010 excel version


Conditional Formatting


Highlight applicable range >>


Cell with first hole score


Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true:
=D$3<=$C6
Format… [Number, Font, Border, Fill]
OK >> OK

Excel Workbook
	A	B	C	D	E	F	G	H	I	J
1	For example
2	Hole Number:			1	2	3	4	5	6	7
3	Hole Handicap			5	3	1	7	1	9	5
4	Par			2	2	4	4	6	5	3
5			Player handicap
6	Players:	Johnathan	4	4	2	5	4	5	5	2
7		Bill	7	4	3	4	6	7	4	4
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
D6	1. / Formula is =D$3<=$C6	Abc
D7	1. / Formula is =D$3<=$C6	Abc