How do I highlight duplicate data on a spreadsheet?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a column of data on an Excel spreadsheet that should be unique codes.
I want to highlight any cells that contain duplicated data. Any idea how to
do this?
 
use conditional formatting
format>conditional format
formula
=countif(d:d,d1)>1
format as desired
apply to all desired cells
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding and Isolating Duplicates 4
Excel Highlighting duplicates 0
Find Duplicate in a Row 8
Delete duplicate data in a single cell 10
Highlight Highest Amount 2
Eliminate Duplicate Entries in Order to Create Labels Using Mail M 3
find duplicates 5
How to filter Unique values from Duplicates 6

Back
Top