Need to highlight a row that is duplicated

Hi all need help setting a rule and have no idea how to do it but know that it is achievable.

I get sent a spreadsheet daily and it consists of names and address of customers that i visit.

What I do is copy and paste the spreadsheet i recieve daily into a main spreadsheet with previous entries.

It looks a little like this:

AM MISS Jennie newton #07949087357 12 Mountwood
AM MRS Shaheen Zaman Khan #02036241594 121 Manor Road North
AM MISS Zakiyya Devaney #02083914847 29 Thrigby Road
I need it to recognise if i have been the before and highlight the row in a colour automatically when i copy and paste each days work in.
thanks russell

hi alan each one is in its own cell so names in one addresses in another phone number in another all i need is it to spot any off the cells that are duplicated wether that be there name address or there phone number. thanks

Well, if your data starts in row 1, and the numbers (#07949087357) are in column D, then highlight all of the cells across the rows with data and down to the bottom of your list and apply this formula for conditional formatting:

Formula:

Please Login or Register  to view this content.

I went with basing the CF off of the #'s because there may be duplicates in other fields.

-Moo

Will that highlight the whole row ? as there is data in that row that matches a previous row.

It will highlight any row where there is a duplicate #xxxxxxxxxxx. Provided you assigned the formula to the correct column (the column that the #'s are stored in).

- Moo

russellhiedi:

My conditional formatting formula is exactly the one that is used on that linked page. If you need to look in column F instead of column D, then highlight the array of cells, open the Conditional Format dialog, and change the formula to this:

Formula:

Please Login or Register  to view this content.

- Moo