Excel Forum
Similar Content
Easily Compare Duplicate Values in Excel
Tutorial: Here, I'll show you a simple technique to quickly and easily compare large lists of duplic...
Delete Duplicate Values in All Versions of Excel
Tutorial: How to delete duplicate values from a data set in all versions of Excel.  This includes Ex...
Highlight Duplicate Values in Excel
Tutorial: How to highlight duplicate values in a list. Also, how to arrange those values next to ea...



Excel Magic Trick 514: Conditional Formatting Duplicate Values (3 Methods)


Methods: 1) Excel 2007 built-in method, 2) COUNTIF functions, 3) COUNTIF function for whole row
See how to
In Excel 2007 / 2010 use Conditional Formatting:
1) Highlight cells with seat names
2) On the Home ribbon, go to the Styles group, then to Conditional Formatting, then to Highlight Cells Rules, Then to Duplicate Values
In Excel 2003 and earlier use Conditional Formatting
1) Format menu, Conditional Format
2) Select Is Formula from first textbox
3) Enter formula: =COUNTIF($A$1:$A$8,A1) Greater than 1 (this is simple example where names are in range A1:A8.
4) add formatting





Got a Question? Ask it Here in the Forum.