question regarding cell duplication

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..
 
B

Bernie Deitrick

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
 

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

Cell colour change if formula displays false 3
List similar to Auto-Filter's? 7
Copying the colour of one cell to anothers. 0
Help 2
Need to count no. of rows where cell in column A = "value1" AND cellin column B (same row) = "value2 2
Need to count cells in Column1 where each cell's row also hasspecified value in Column2 2
Changing cell color with a formula? 4
Using colour conditional formatting to show whether due date has past 0

Top