I need to highlight duplicate values, comparing two columns. I'm working on excel 365. The rows have contain words that have cut and pasted from other workbooks. When I use Conditional Formatting, the duplicates are not highlighted.
Solved by F. H. in 16 mins