Hi,

How can I highlight cells in a list of numbers on Sheet1 where the number of
occurrences of that number on Sheet2 is not equal to 1?

Sheet1 has a list of unique numbers that will not change.
Sheet2 is an entry sheet were a list will be entered.
Assuming both lists will start in A1 and continue in column A.

On Sheet1 how can I highlight cells in the list where the number of
occurrences of that number on Sheet2 is not equal to 1?

In other words, using the list on Sheet1, I want to know if a number has not
been entered or entered more than once on Sheet2.

Hope this makes sense to someone. Thanks for any ideas.
--
David K.