• Skip to main content
  • Skip to primary sidebar

Technipages

Tutorials and fixes for smartphone, gadget, and computer problems

  • Topics
    • Android
    • Gaming
    • Hardware
    • Internet
    • iOS
    • MacOS
    • Office
    • Software
    • Windows
    • Definitions
  • Product Reviews
  • Downloads
  • About Technipages
How to Highlight Duplicate or Unique Values in Excel

How to Highlight Duplicate or Unique Values in Excel

By Mitch Bartlett 1 Comment

If you have the need to highlight cells with duplicate or unique values in Microsoft Excel 2016 or 2013, here’s an easy way to do it.

  1. Open the Excel sheet, then select the “Home” tab.
  2. Select the “Conditional Formatting” button.
  3. Choose “Highlight Cell Rules“.
  4. Choose “Duplicate Values…“.
    Excel Highlight Duplicate Values
  5. Now you can choose to highlight “Duplicate” or “Unique“, then choose the color you would like to highlight them with.
    Excel Select Duplicate or Unique

Your duplicate or unique data will then be marked as desired.

You Might Also Like

  • Copy and Paste Values Without Formulas in Excel 2019, 2016, & 365
    Copy and Paste Values Without Formulas in Excel 2019, 2016,…
  • How to Use the Unique Function in Google Sheets
    How to Use the Unique Function in Google Sheets
  • How to Find and Delete Duplicate Files
    How to Find and Delete Duplicate Files
  • How to Highlight Text in Google Docs
    How to Highlight Text in Google Docs
  • How to Highlight Text in Google Slides
    How to Highlight Text in Google Slides
  • How to Highlight Text in Google Sheets
    How to Highlight Text in Google Sheets
  • How to Add Highlight Tool to Google Docs
    How to Add Highlight Tool to Google Docs
  • Adobe Reader: Change Highlight Color
    Adobe Reader: Change Highlight Color
  • How to Remove Duplicate Contacts on Any Android Device
    How to Remove Duplicate Contacts on Any Android Device

Filed Under: Office Tagged With: Excel 2013, Excel 2016

Reader Interactions

Comments

  1. Wendy says

    August 15, 2017 at 10:30 am

    Great help — thanks for the instructions

Did this help? Let us know!

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Primary Sidebar

Recent Posts

  • How To Install Google Assistant on Galaxy Watch 4
  • How to Build the Best Themed PC for Your Budget
  • Windows 11: How to Change the System Sounds
  • Windows 11: How to Get the Battery Report
  • How to Fix Mic Not Working on Android
  • Google Maps: How to Use Coordinates
  • How to Turn Yourself into WhatsApp Stickers
  • What to Do When WhatsApp Web Doesn’t Work

Who’s Behind Technipages?

Baby and Daddy My name is Mitch Bartlett. I've been working in technology for over 20 years in a wide range of tech jobs from Tech Support to Software Testing. I started this site as a technical guide for myself and it has grown into what I hope is a useful reference for all.

© Copyright 2022 Technipages · All Rights Reserved · Privacy