Configuration To set up a check box, you need to establish whether it's checked or unchecked by default and set up a status field to contain its values.

If you wish to count the same or duplicate values in a column only once in Excel or the count of occurances of duplicate values, read this article.

How to highlight values Excel has a built-in conditional rule that highlights unique values. You don’t have to come up with a special formula—you just run though a few clicks.