How do I highlight duplicate data on a spreadsheet?

G

Grim72

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?
 
D

Don Guillett

use conditional formatting
format>conditional format
formula
=countif(d:d,d1)>1
format as desired
apply to all desired cells
 
Top