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?

Members

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.

•  Extended Cut Video - Silver
•  Database Template Download - Gold

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today!

Links

DCount: https://599cd.com/dcount
DLookup: https://599cd.com/dlookup
Calculated Query Fields: https://599cd.com/calculated
Double Double Quotes: https://599cd.com/DoubleDouble
Expression Is: https://599cd.com/ExpressionIs
Cartesian Product: https://599cd.com/ac223

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.