Highlight highest value

Hi all,
this forum has helped me till now but I'm going blurry eyed looking for this solution, here goes:

I have a row of 11 values with the lowest 10 values summed, I want to highlight the highest value of only the summed cells in this case 9 (cell DI5) does this make sense?
I'm going to bed now but so thanks in advance
Astoria results1.xlsx

Hi, welcome to the forum.

DI5 is 10th lowest not 9th. Right? How about tie values? eg. in DB16, DC16 10th lowest is 10. So how do you want to highlights. both cells or just the 1st number.

I only can see 8 in DI5 instead of 9

Select DB5:DL20, then try this formula in Conditional Formatting.

Please Login or Register  to view this content.

See the attached.