Excel Forum
Similar Content
Better Edit Excel Formulas in the Conditional Formatting Window or Name Manager
Tutorial: Excel quickie tutorial that will show you a great tip for working with formulas within th...
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...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course




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.