VBA Highlight Rows with Duplicates

[anthonyexcel]

Good morning,
I have about 350,000 rows of data. The rows have a blank row in between each record. I need to highlight the duplicates in each row. Can anyone please assist me. A sample of the data set is below. Thanks in advance!

ID	2010	2011	2012	2013	2014	2015	2016	2017
2	1	1	2	3	4	5	6	7
4	1	2	3	4	5	6	7	8
6	K	K	1	2	2	3	4	5
23	K	1	1	2	3	4	5	5
24	1	2	3	4	5	6	7	8
25	K	1	2	3	4	5	5	6
26	K	1	2	2	3	4	5	6
27	K	1	2	3	4	5	6	7
35	K	K	1	2	3	4	5	6

<tbody>
</tbody>

 

[Fluff]

Select your data, in the case above B2:I18
Conditional formatting > New rule > use a formula >
=AND(B2<>"",COUNTIF($B2:$I2,B2)>1)
and select your format.

 

[anthonyexcel]

Thanks Fluff that works! I appreciate the help on this post! Thanks again!

 

[Fluff]

You're welcome & thanks for the feedback