question regarding cell duplication

  • Thread starter Thread starter al
  • Start date Start date
A

al

Gooday,

I would like to create a spreadsheet, and I want to track any
duplicate numbers entered in the cells, if a duplication is detected
for e.g under column A it will turn red or any other colour. Can
anyone help out if this is acheivable.

for e.g

123456
132584
123456 ( should detect this and cell should change colour
automatically)

Thanks in advance..
 
Al,

Use conditional formatting.

To highlight duplicate entries in column A, select column A, the use
Format | Conditional Formatting..., select "Formula is" and use
the formula
=COUNTIF(A$1:A1,A1)>1
Set the format fill color to red, and you're done.

HTH,
Bernie
 
Back
Top