is there a function or macro that will highlight a cell if it is a duplicate
so if i had the word house in column a row 3, and then again in column a row
455, that it would highlight the cell (or both the cells)??