I have a excel spreadsheet with loan numbers. I need to make sure there are no unique numbers and I have been using conditional formatting to highlight these. I deleted one number which should have made its partner unique. I cleared the formatting and then did highlight unique. This number is not highlighting. If I try finding the number to see if it is somewhere else, I can only find the one. Why is this happening? What can I do to ensure the formatting will work after deleting a duplicate?

Hi,

Do you mind share us a sample file or some screenshots? It'll help us understand your issue clarity.

Regards,

George Zhao
TechNet Community Support

I can't share my actual document and I can't seem to replicate what happened. It's never happened before. I wish I could explain it better or share a sample. I may just wait and see if it happens again. Thank you for replying. :)

Dumb question - are you 100% certain that there were only two numbers in the set?

I did try Find to see if it snuck in somewhere but I only got one result. I have to trust that because there were too many loans to manually look. Thats why I got worried because I don't want it to happen again and I don't notice.

most possibility is mistaken opeation. take care for the data.

KR