Excel Forum

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.