MrShorty, I encountered a problem. while the format you gave me above is working there is an issue with using that approach. The reason I needed help with this is because I'm trying to compare a set of already drawn lottery numbers with a set from a different game. I copied the winning numbers from the lottery website and pasted them into excel which entered them without the zeros for numbers below ten like this.
8,9,10,19,34-1,2. the other set of numbers I have to enter manually that's why I needed help with the above format. Later the goal was to compare the two lists for numbers that are identical by using the conditional formating and highlighting duplicates. now because the both numbers are written in a different format excel doesn't see them as identical. The copied number is 8,9,10,19,34-1,2 the manually entered number is 08,09,10,19,34-01,02. Although they are the same excel doesn't see them that way. How should I resolve this? Thank you so much.