Highlight only one occurrence of value in table

[mbeardsl]

I have a table of placings in a series of races and the associated points applicable to those placings. E.g.

Name | Place1 | Points1 | Place2 | Points2 | etc

We drop the lowest points score (best 4 of 5 races), and I'd like to highlight that points amount. But I only want to highlight it the first time it occurs. In other words, if someone earns 35,35,35,31,31 points I only want to highlight one of the 31 values.

Is this possible? I've been playing with MATCH() and conditional formatting but just can't figure it out. I feel like the data being organized in columns and separated by the placing columns is making it difficult.

Thanks for your help in advance.

MB

 

[FDibbins]

Awesome, happy to help.

All that last part is doing, is only looking at the Points headings, and making sure the the cell actually contains something