I am trying to use conditional formatting to flag records that have duplicate values in a given text field. I'm not easily finding the right function to compare the just entered text to the rest of the index for that field. Am I approaching this the wrong way? Should I be thinking script rather than using the conditional formatting formula line? Is there really any difference?