Users will be entering a list of data across a row. They will be selecting
the datum from a "validated" drop-down.
We need to ensure that they don't select any duplicate entries from the
drop-down when completing their list.
I researched a 'Conditional Formatting' solution that will change the
formatting. I tried this, but when I tried to copy the Formatting on
pre-existing lists, I could not get it to not copy the Value as well(?).
Any suggestions for checking and flagging duplicates in a list?
Thanks in advance.