need info on conditional formatting-duplicates

I have a question-using excel. I have 64000+ lines of information. In order to try to narrow down which debit card number does not have an offset, I am using the conditional formatting duplicate form...