Highlight a duplicate entry in a portal row. Is this possible?
Is it possible to have rows in a portal highlight if a duplicate entry is made? We do a lot of data entry with part numbers, part desciptions, etc. for each main item. I would like to ask if, when someone is keying in a duplicate part number, is there a way that both rows would highlight? Would just make it easier to find them, rather than having to look at a sort.
I've done a lot of conditional formatting, but not sure how to pull the trigger when 2 rows are the same.
Any help is much appreciated!