It should be pretty simple.
Compare the value entered in cell (for e.g. F2 in excel) with all the last columns of all rows.
Try that and let me know. If you find it difficult I will send you a sample PDF.
Yes, please send sample! I have been playing around with it in LiveCycle and I can get some cells to work and others do not! Getting frustrated. Thank you so much.
Nevermind... I got a response from Niall O\'Donovan. He created a sample found here http://assure.ly/AcRpsv. Using this sample I was able to play around a bit and get it to work exactly how I need it to. Thanks for the responses!
sorry to revive old thread but I would also like to know how to highlight duplicates but in columns, I.e., duplicate values going down a column.
just a simple script will do instead of the complicated script on assuredynamics that helped the original poster.