8 Replies Latest reply on Mar 24, 2017 7:24 AM by JamesCarr

    Trouble with conditional formatting on a number field

    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