I have a excel workbook with many rows of data. There are also many worksheets - each worksheet relates to a week of data. In column E of all worksheets combined there cannot be duplicates. So I want the workbook to prevent me from entering a duplicate value. A prompt saying "Duplicate Found" or the cell going red would be good.
I'd imagine this would be done on a change event with VB of a Macro Enabled Workbook