Double-click your Excel document. This will open the spreadsheet in Excel, allowing you to check it for cells containing duplicate values by using the Conditional Formatting feature. If you want to look for duplicates but don't want to delete them by default, this is a good way of doing so.

First, the previous conditional formatting rule. Select the range A1:C10. On the Home tab, in the Styles group, click Conditional Formatting. Click New Rule.

Select 'Use a formula to determine which cells to format'. Enter the formula =($A$1:$C$10,A1)=3 11. Select a formatting style and click OK. Excel highlights the triplicate names.

Explanation: =($A$1:$C$10,A1) counts the number of names in the range A1:C10 that are equal to the name in cell A1. If COUNTIF($A$1:$C$10,A1) = 3, Excel formats the cell. Because we selected the range A1:C10 before we clicked on Conditional Formatting, Excel automatically copies the formula to the other cells.

Thus, cell A2 contains the formula =COUNTIF($A$1:$C$10,A2)=3, cell A3 =COUNTIF($A$1:$C$10,A3)=3, etc. Notice how we created an ($A$1:$C$10) to fix this reference. Note: you can use any formula you like.

For example, use this formula =COUNTIF($A$1:$C$10,A1)> Python tutorial for mac users beginners youtube. 3 to highlight the names that occur more than 3 times.