Use Excel conditional formatting to highlight duplicate entries in a column:
1. Select range A2:A11
2. Choose Format|Conditional Formatting
3. From the first dropdown, choose Formula Is
4. For the formula, enter
=COUNTIF($A$2:$A$11,A2)>1
5. Click the Format button.
6. Select a font colour for highlighting.
7. Click OK, click OK
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment