Hello

I have an issue with long numbers (16 digits). To display them correctly in excel I formatted the cells as text. This part works fine, but now for some reason conditional formatting marks different numbers as duplicates
In my case 3081281170122602 and 3081281170122601 are considered as duplicates by excel.
Please see the file attached.

Any idea how to get around this issue?

Thanks in advance
Peter

duplikaat.xlsx