Highlight duplicate values

[ghrek]

Hi

I have a worksheet that I have numerous data in and sometimes they get duplicated.

Is there anyway that I can highlight the duplicate values that are exactly the same in columns A-D. Ive tried conditional formatting on excel and that highlights all duplicate values in each individual column but I need it to highlight if a duplicate is all the way across all 4 columns.

It will also need to look all the way down the workbook for the duplicate entries.

Any ideas?

Thanks

 

[SpillerBD]

Re: How can I highlight duplicate values

Duplicate values or duplicate sets/rows of data?

 

[ghrek]

Re: How can I highlight duplicate values

Sorry I meant duplicate rows of data.

Lets say row 1 and row 99 have exactly the same data in columns A-D I need them highlighted or better still if it can be done in column E put the word DUPLICATE beside all the ones that are duplicated.

 

[Fluff]

Re: How can I highlight duplicate values

How about something like
=COUNTIFS($A:$A,$A1,$B:$B,$B1,$C:$C,$C1,$D:$D,$D1)>1

 

[kweaver]

Re: How can I highlight duplicate values

Of, adding to Fluff, if you want the word in E:

=IF(COUNTIFS($A:$A,$A1,$B:$B,$B1,$C:$C,$C1,$D:$D,$D1)>1,"DUPLICATE","")