Highlight duplicate data

P

psilzle

I need to format a column to highlight a cell if there is another cell
in that column with the same data. We are keeping track of program
numbers and we do not want to duplicate them. If I enter program 495
and it already exists, how can I get it to highlight red to notify
there is a duplicate?

Thank you

Paul Silzle
 
D

Dodo

I need to format a column to highlight a cell if there is another cell
in that column with the same data. We are keeping track of program
numbers and we do not want to duplicate them. If I enter program 495
and it already exists, how can I get it to highlight red to notify
there is a duplicate?

Thank you

Paul Silzle
Click to expand...

Could you use a column for a flag? If it works, you could hide it after
entering a formula.

Suppose the first data entry is to be accepted. Only duplicates down the
column will be signaled.
Suppose your headers are in Row1.
Suppose your data are in column A (starting from A2 down) and your flags in
column B.

Then enter in B3:

=VLOOKUP(A3,$A$2:A2,1,FALSE)

Copy this formula down.

Conditional format in A3:

Formula is: =A3=B3

Format if condition is met: Pattern is: select the colour you like most!

You can hide column B to suppress the formula results.
 
Top