By Richard Rost 3 years ago
Highlight Duplicate Values with Conditional Formatting
Learn how to use conditional formatting to show duplicate values in a field / column at a glance in both Microsoft Access and Excel.
Jerome from Argentina (a Silver Member) asks: In Excel, you can show values in a column that are duplicates using Conditional Formatting – Highlight Cells Rules – Duplicate Values. Is it possible to do the same thing in Access?
I'll show you how to create a query to show duplicate customers based on any number of fields you choose. So you can say "show me all of the customers that have the same first name, last name, and address." You will learn how to create a Cartesian Product.
Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the database template from class plus get access to the Code Vault. If you signed up on YouTube you have to register on my YouTube Find User page so I can set up your account here on my web site. If you're not a member, Join Today!
Subscribe to Highlight Duplicates
Get notifications when this page is updated
|Keywords: TechHelp Access find duplicates, show duplicate records, conditional formatting, excel, msexcel, #excel, #msexcel, highlight cells rules, duplicate values, dcount, dlookup, calculated query fields, double quotes, expression is, cartesian product, display PermaLink Highlight Duplicates with Conditional Formatting in Microsoft Access|