22 Replies Latest reply: Aug 4, 2010 12:10 PM by a.danielato RSS

    seeing duplicates across two fields

    rosie_beasley

      I have three fields supporter number, last name and postcode. What I am trying to do is to put a condition on the background colour of supporter number to say if the postcode and last name combination appears twice i want the supporter number to be coloured.

      I understand where to put this condition but I cannot work out what condition to use

       

      thanks in advance

      Rosie