Highlight Highest Three in Multiple Columns

[mlmrob]

Guys

I ahve the following spreadsheet

What I have been doing is highlighting the top 3 for each race in the AVLR and MAXLR columns manually using Conditional Formatting. Is there any way this could speeded up with a formula as somedays there are quite a lot of races and I have to use Conditional Formatting to highlight the top 3, three times for each race as the numbers are from a horse's last race, AVLR, MAXLR, second last race AV2, MAX2, and third last race AV3 abd MAX3.

Thank you

Rob

 

[awoohaw]

TRY THIS: It includes TIES:

mr excel questions 24.xlsm
	A	B	C	D	E	F	G	H	I	J
1
2		36	39	32	40	10	19	14	39
3		29	21	25	34	24	39	15	25
4		28	15	24	34	35	39	24	33
5		18	17	23	27	38	25	12	39
6		32	29	14	10	12	12	13	11
7		36	28	25	11	30	15	38	15
8		30	10	15	21	16	32	20	15
9		22	30	21	11	13	17	38	20
10		10	30	24	25	39	11	24	27
11		13	13	37	17	33	16	23	25
12
mlmrob

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B2:I11	Expression	=B2>=LARGE($B2:$I2,3)	text	NO

 

[Fluff]

How about

=H2>=AGGREGATE(14,6,H$2:H$100/($B$2:$B$100=$B2),3)

 

[mlmrob]

Thanks Fluff, worked a treat

 

[Fluff]

Glad we could help & thanks for the feedback.