Conditional Formatting- Highlight Duplicate Values

Hello, pulling my hair out and didn't have much to start with!

I have copied data from a excel file emailed to me into column beside my data. I can't get the duplicate value rule to work, it won't highlight duplicate values other than the duplicate values that are in my data and the data I copied in. The data is text if that helps? Text values definitely duplicate between the two columns. I have copied all and paste specialed, made sure that both columns were formatted the same, etc- Nothing on excel has ever stumped me before.

To get the data from the email to the same format I had to use the 'text to columns', 'delimited', 'tab' (ticked by default) and other '(', just in case this causes any issues? Please help

Thank you

Christopher

Christoper,
This thread could perhaps help you.

http://www.excelforum.com/excel-gene...highlight.html

Hello, I had a look at the previous suggested solution- unfortunately it did not help me, hopefully I have attached the file in question. For example when trying to highlight duplicate values 'Bognor' appears at the top of column B, also 5 or 6 down in column A but it does not recognise as a duplicate?

Any suggestions

Christopher ,

It's hard to see , but your data in column A is not the same as column B
If you select a cell in column A and hit F2 you'll see that the value has a trailing space.
So in order to have the same values in both columns , you must first TRIM the value in column A ( and maybe column B as well)
After that you can search for duplicates with the suggested conditional formatting.

If problems persists , keep replying to this forum.

Problem solved, thank you MarMO, never come across this trailing space before

Christopher