This video explains how to highlight duplicate values in the same column in a different colour. It demonstrates two methods, one of which highlights the first occurrence and the other that doesn't.

This video tutorial will be useful to you if you need to:
Highlight duplicates in Excel
Colour duplicates in Excel using conditional formatting
Identify duplicates in Excel without deleting/removing them
------------------------