I am trying to create a solution to determine the unique low score on a given hole for my golf group. When the scores are entered I want to highlight the field that has the lowest number (no duplicates). My problem is defining the lowest number. I thought that I could use a global variable starting with the first record. Then entering the following records I could make the evaluation based on the variable. I can't figure out how to make it unique so it stays highlighted.
This is what I would expect:
Rec 1 5
Rec 2 4
Rec 3 4
Rec 4 3 this would be unique change the field background to a colour
Rec 5 4
If there are no unique entries in the field for all the records nothing would be highlighted.