Find and highlight duplicate entries

**yrndtn** · 12-01-2009, 04:20 AM

Hello,

I have a list of people that I update once in a while. I need to find duplicate entries at the date of birth column and highlight this. Could not find what I want online (found some macros to delete the value, not to highlight).

Thanks

**teylyn** · 12-01-2009, 04:26 AM

Hi,

with your data in column A

- to count the duplicates in column B:

B1 =COUNTIF($A$1:$A$13,A1)

- to highlight the duplicates in column A
select all cells with data in column A
on the Home tab click Conditional formatting - New Rule
select "use a formula to determine...."
enter this formula
=COUNTIF($A$1:$A$13,A1)>1
select a format, for example a colored fill.

adjust ranges to suit

hth

**yrndtn** · 12-01-2009, 06:28 AM

Thanks! it is exactly what i needed (though I tries conditional formatting but it doesn't work for me...)

**teylyn** · 12-01-2009, 06:30 AM

yrndtn,

though I tries conditional formatting but it doesn't work for me

is that in relation to my suggestion? I'd be happy to look at a sample of your data and help you get it right. You know how to upload a workbook, right? (click "go advanced" below and then the paper clip icon....)

cheers