AnsweredAssumed Answered

Trouble with conditional formatting on a number field

Question asked by JamesCarr on Mar 23, 2017
Latest reply on Mar 24, 2017 by JamesCarr

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.

 

 

Thanks Jim

Outcomes