you can simply use conditional formatting to do this. Select the two columns, Open conditional formatting , highlight cells for double data, no matter if data is numeric or text. This will work even if you continue to add data to those columns, if you add a value that already added, it will be highlighted automatically.
|