Compare on a row

[Romano_odK]

Good afternoon,

Got a long sheet with 3 columns with GTIN codes. These need to be compared to each other and when one is off I need the line to be red for example. So if A2, B2 and C2 are not the same I need to be able to see that. Is that possible to do?

Thank you for your time.

Romano

 

[Fluff]

You can do that with conditional formatting, select A2 to the last row in C & use this formula

=countifs($A2:$C2,$A2)<>3

 

[mumps]

Try:

Sub CompareData()
    Application.ScreenUpdating = False
    Dim v As Variant, dic As Object, i As Long
    v = Range("A2", Range("A" & Rows.Count).End(xlUp)).Resize(, 3).Value
    Set dic = CreateObject("Scripting.Dictionary")
    For r = LBound(v) To UBound(v)
        For c = 1 To UBound(v, 2) - 1
            If v(r, c) <> v(r, c + 1) Then
                Range("A" & r + 1).Resize(, 3).Interior.ColorIndex = 3
                Exit For
            End If
        Next c
    Next r
    Application.ScreenUpdating = True
End Sub

 

[Romano_odK]

You can do that with conditional formatting, select A2 to the last row in C & use this formula

=countifs($A2:$C2,$A2)<>3

You can do that with conditional formatting, select A2 to the last row in C & use this formula

=countifs($A2:$C2,$A2)<>3

Thank you this as well as the other solution provides work perfectly.

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[Romano_odK]

Try:

Sub CompareData()
    Application.ScreenUpdating = False
    Dim v As Variant, dic As Object, i As Long
    v = Range("A2", Range("A" & Rows.Count).End(xlUp)).Resize(, 3).Value
    Set dic = CreateObject("Scripting.Dictionary")
    For r = LBound(v) To UBound(v)
        For c = 1 To UBound(v, 2) - 1
            If v(r, c) <> v(r, c + 1) Then
                Range("A" & r + 1).Resize(, 3).Interior.ColorIndex = 3
                Exit For
            End If
        Next c
    Next r
    Application.ScreenUpdating = True
End Sub

One little question, how can I get it to start on column E3? So, E3,F3 and G3. Thank you again.

 

[mumps]

Just replace all the A's in the code with an "E". There are three occurrences.

 

[Romano_odK]

Just replace all the A's in the code with an "E". There are three occurrences.

Good morning,

I changed the settings accordingly. Now what I get is that to the eye the same values are marked as not equal. Do you understand why?

Project MDB.xlsm
	A	B	C		E	F	G	H
1
2
3	Artikelcode	Omschrijving	Leverancier		GTIN_leverancier	Zoekcode	GTIN_Verkoopeenheid	GTIN_Omverpakking
4	100000	Vito Glaserfix 111 6x2 mm wit - 10x25 m	10027 - Vito GmbH		8712759037825	8712759037825	8712759037825	4044041014158
5	100001	Vito Glaserfix 111 6x2 mm zwart - 10x25 m	10027 - Vito GmbH		8712759037832	8712759037832	8712759037832	4044041014165
6	100002	Vito Glaserfix 111 6x3 mm wit - 10x25 m	10027 - Vito GmbH		8712759037849	8712759037849	8712759037849	4044041014172
7	100003	Vito Glaserfix 111 6x3 mm zwart - 10x25 m	10027 - Vito GmbH		8712759037856	8712759037856	8712759037856	4044041014189
8	100004	Vito Glaserfix 111 6x4 mm wit - 10x25 m	10027 - Vito GmbH		8712759037863	8712759037863	8712759037863	4044041014196
9	100005	Vito Glaserfix 111 6x4 mm zwart - 10x25 m	10027 - Vito GmbH		8712759037870	8712759037870	8712759037870	4044041014202
10	100006	Vito Glaserfix 111 9x2 mm wit - 10x25 m	10027 - Vito GmbH		8712759037917	8712759037917	8712759037917	4044041014011
11	100007	Vito Glaserfix 111 9x2 mm zwart - 10x25 m	10027 - Vito GmbH		8712759037924	8712759037924	8712759037924	4044041014028
12	100008	Vito Glaserfix 111 9x3 mm wit - 10x25 m	10027 - Vito GmbH		8712759037955	8712759037955	8712759037955	4044041014035
13	100009	Vito Glaserfix 111 9x3 mm zwart - 10x25 m	10027 - Vito GmbH		8712759037962	8712759037962	8712759037962	4044041014042
14	100010	Vito Glaserfix 111 9x4 mm wit - 10x25 m	10027 - Vito GmbH		8712759035500	8712759035500	8712759035500	4044041014059
15	100011	Vito Glaserfix 111 9x4 mm zwart - 10x25 m	10027 - Vito GmbH		8712759038341	8712759038341	8712759038341	4044041014066
16	100012	Vito Glaserfix 111 9x5 mm wit - 10x10 m	10027 - Vito GmbH		8712759037993	8712759037993	8712759037993	4044041014455
17	100013	Vito Glaserfix 111 9x5 mm zwart - 10x10 m	10027 - Vito GmbH		8712759038006	8712759038006	8712759038006	4044041014080
18	100014	Vito Glaserfix 111 9x6 mm wit - 10x10 m	10027 - Vito GmbH		8712759038013	8712759038013	8712759038013	4044041014097
19	100015	Vito Glaserfix 111 9x6 mm zwart - 10x10 m	10027 - Vito GmbH		8712759038020	8712759038020	8712759038020	4044041020661
20	100016	Vito Glaserfix 111 12x3 mm zwart - 10x25 m	10027 - Vito GmbH		8712759037788	8712759037788	8712759037788
21	101000	Vito Glaserfix 111 9x1 mm wit - 33 m	10027 - Vito GmbH		8712759037887	8712759037887	8712759037887	4044041221341
22	101001	Vito Glaserfix 111 9x1 mm zwart - 33 m	10027 - Vito GmbH		8712759037894	8712759037894	8712759037894	4044041220689
23	101002	Vito Glaserfix 111 9x2 mm zwart - 10 m	10027 - Vito GmbH		8712759037900	8712759037900	8712759037900	4044041014349
24	101003	Vito Glaserfix 111 9x4 mm wit - 5 m	10027 - Vito GmbH		8712759037979	8712759037979	8712759037979	4044041014240
25	101004	Vito Glaserfix 111 9x4 mm zwart - 5 m	10027 - Vito GmbH		8712759037986	8712759037986
26	103000	Vitoglas 120 celband 6x2 mm grijs - 10x10 m	10027 - Vito GmbH		8712759010156	8712759010156	8712759010156	4044041034019
27	103001	Vitoglas 120 celband 6x2 mm wit - 10x10 m	10027 - Vito GmbH		8712759015007	8712759015007	8712759015007	4044041034026
28	103002	Vitoglas 120 celband 6x3 mm grijs - 10x10 m	10027 - Vito GmbH		8712759010255	8712759010255	8712759010255	4044041213148
29	103003	Vitoglas 120 celband 6x3 mm wit - 10x10 m	10027 - Vito GmbH		8712759015106	8712759015106	8712759015106	4044041036402
30	103004	Vitoglas 120 celband 6x4 mm grijs - 10x10 m	10027 - Vito GmbH		8712759010309	8712759010309	8712759010309
31	103005	Vitoglas 120 celband 6x4 mm wit - 10x10 m	10027 - Vito GmbH		8712759015205	8712759015205	8712759015205
32	103006	Vitoglas 120 celband 6x5 mm grijs - 5x10 m	10027 - Vito GmbH		8712759010408	8712759010408	8712759010408
33	103007	Vitoglas 120 celband 9x2 mm grijs - 5x20 m	10027 - Vito GmbH		8712759010507	8712759010507	8712759010507	4044041221662
34	103008	Vitoglas 120 celband 9x2 mm wit - 5x20 m	10027 - Vito GmbH		8712759015403	8712759015403	8712759015403	4044041018019
35	103009	Vitoglas 120 celband 9x3 mm grijs - 5x20 m	10027 - Vito GmbH		8712759010606	8712759010606	8712759010606	4044041018040
36	103010	Vitoglas 120 celband 9x3 mm wit - 5x20 m	10027 - Vito GmbH		8712759015502	8712759015502	8712759015502	4044041018347
37	103011	Vitoglas 120 celband 9x4 mm grijs - 5x20 m	10027 - Vito GmbH		8712759030505	8712759030505	8712759030505	4044041018064
38	103012	Vitoglas 120 celband 9x4 mm wit - 5x20 m	10027 - Vito GmbH		8712759015601	8712759015601	8712759015601	4044041018408
39	103013	Vitoglas 120 celband 9x5 mm grijs - 10x10 m	10027 - Vito GmbH		8712759030604	8712759030604	8712759030604	4044041214961
40	103014	Vitoglas 120 celband 9x5 mm wit - 10x10 m	10027 - Vito GmbH		8712759015702	8712759015702	8712759015702	4044041039434
41	103015	Vitoglas 120 celband 9x6 mm grijs - 10x10 m	10027 - Vito GmbH		8712759010903	8712759010903	8712759010903	4044041034170
42	103016	Vitoglas 120 celband 9x6 mm wit - 10x10 m	10027 - Vito GmbH		8712759015809	8712759015809	8712759015809	4044041034187
43	103017	Vitoglas 110 celband 9x8 mm grijs - 10x10 m	10027 - Vito GmbH		8712759011009	8712759011009	8712759011009	4044041028636
44	103018	Vitoglas 120 celband 12x2 mm grijs - 10x20 m	10027 - Vito GmbH		8712759011108	8712759011108	8712759011108
45	103019	Vitoglas 120 celband 12x2 mm wit - 10x20 m	10027 - Vito GmbH		8712759034855	8712759034855	8712759034855	4044041034200
46	103020	Vitoglas 120 celband 12x3 mm grijs - 10x20 m	10027 - Vito GmbH		8712759011306	8712759011306	8712759011306	4044041035535
47	103021	Vitoglas 120 celband 12x4 mm grijs - 10x20 m	10027 - Vito GmbH		8712759011207	8712759011207	8712759011207	4044041001936
48	103022	Vitoglas 120 celband 12x5 mm grijs - 10x10 m	10027 - Vito GmbH		8712759011405	8712759011405	8712759011405	4044041220696
49	103023	Vitoglas 120 celband 12x5 mm wit - 10x10 m	10027 - Vito GmbH		8712759034893	8712759034893	8712759034893
50	103024	Vitoglas 120 celband 12x6 mm grijs - 10x10 m	10027 - Vito GmbH		8712759011504	8712759011504	8712759011504
51	103025	Vitoglas 120 celband 15x2 mm grijs - 5x20 m	10027 - Vito GmbH		8712759011603	8712759011603	8712759011603	4044041035573
52	103026	Vitoglas 120 celband 15x2 mm wit - 5x20 m	10027 - Vito GmbH		8712759034916	8712759034916	8712759034916
53	103027	Vitoglas 120 celband 15x3 mm grijs - 5x20 m	10027 - Vito GmbH		8712759011702	8712759011702	8712759011702	4044041034293
54	103028	Vitoglas 120 celband 15x4 mm grijs - 5x20 m	10027 - Vito GmbH		8712759011801	8712759011801	8712759011801	4044041035627
55	103029	Vitoglas 120 celband 15x4 mm wit - 5x20 m	10027 - Vito GmbH		8712759034923	8712759034923	8712759034923
56	103031	Vitoglas 120 celband 19x2 mm wit - 5x10 m	10027 - Vito GmbH		8712759034947	8712759034947	8712759034947
57	103032	Vitoglas 120 celband 19x3 mm grijs - 5x20 m	10027 - Vito GmbH		8712759034954	8712759034954	8712759034954	4044041034316
58	103033	Vitoglas 120 celband 19x3 mm wit - 5x20 m	10027 - Vito GmbH		8712759038273	8712759038273	8712759038273
59	104000	Vitoglas 120 celband 6x2 mm grijs - 600 m	10027 - Vito GmbH		8712759020100	8712759020100	8712759020100	8712759020155
60	104001	Vitoglas 120 celband 6x3 mm grijs - 420 m	10027 - Vito GmbH		8712759020209	8712759020209	8712759020209	4044041019627
61	104002	Vitoglas 120 celband 6x4 mm grijs - 320 m	10027 - Vito GmbH		8712759020308	8712759020308	8712759020308	4044041019641
62	104003	Vitoglas 120 celband 9x2 mm grijs - 600 m	10027 - Vito GmbH		8712759020407	8712759020407	8712759020407	4044041019528
63	104004	Vitoglas 120 celband 9x3 mm grijs - 480 m	10027 - Vito GmbH		8712759020506	8712759020506	8712759020506	4044041019542
64	104005	Vitoglas 120 celband 9x4 mm grijs - 360 m	10027 - Vito GmbH		8712759020605	8712759020605	8712759020605	4044041019566
65	104006	Vitoglas 120 celband 9x5 mm grijs - 300 m	10027 - Vito GmbH		8712759020704	8712759020704	8712759020704	4044041019580
66	104007	Vitoglas 120 celband 9x4 mm wit - 360 m	10027 - Vito GmbH		8712759025501	8712759025501	8712759025501	4044041019559
67	104008	Vitoglas 120 celband 9x3 mm wit - 480 m	10027 - Vito GmbH		8712759025402	8712759025402	8712759025402	4044041019535
68	104009	Vitoglas 120 celband 9x2 mm wit - 600 m	10027 - Vito GmbH		8712759025303	8712759025303	8712759025303	4044041019511
69	104010	Vitoglas 120 celband 32x4 mm grijs - 900 m	10027 - Vito GmbH		8,71276E+12	8,71276E+12	8,71276E+12
70	104012	Vitoglas 120 celband 17x4 mm grijs - 1.050 m	10027 - Vito GmbH		8712759075827	8712759075827	8712759075827
71	105000	Coroplast AWX celband 9x3 mm wit - 560 m	10093 - Coroplast Fritz Muller GmbH & Co KG			105000
72	105001	Coroplast AWX celband 9x3 mm wit - 600 m	10093 - Coroplast Fritz Muller GmbH & Co KG		8712759040740	8712759040740	8712759040740	8712759041969
73	105002	Coroplast AWX celband 9x3 mm zwart - 600 m	10093 - Coroplast Fritz Muller GmbH & Co KG		8712759040757	8712759040757	8712759040757	8712759041105
74	105003	Coroplast AWX celband 9x4 mm wit - 450 m	10093 - Coroplast Fritz Muller GmbH & Co KG		8712759040801	8712759040801	8712759040801	8712759041976
75	105004	Coroplast AWX celband 9x4 mm zwart - 450 m	10093 - Coroplast Fritz Muller GmbH & Co KG		8712759040818	8712759040818	8712759040818	8712759041112
76	105005	Coroplast AWX celband 9x5 mm zwart afdekfolie - 300 m	10093 - Coroplast Fritz Muller GmbH & Co KG		8712759069178	8712759069178	8712759069178
77	106000	Coroplast AWX celband 6x2 mm wit - 15x25 m folie	10093 - Coroplast Fritz Muller GmbH & Co KG		8712759040689	8712759040689	8712759040689	8712759041631
78	106001	Coroplast AWX celband 6x2 mm zwart - 15x25 m folie	10093 - Coroplast Fritz Muller GmbH & Co KG		8712759040696	8712759040696	8712759040696	8712759041648
79	106002	Coroplast AWX celband 9x2 mm wit - 10x25 m folie	10093 - Coroplast Fritz Muller GmbH & Co KG		8712759040702	8712759040702	8712759040702	8712759041655
80	106003	Coroplast AWX celband 9x2 mm zwart - 10x25 m folie	10093 - Coroplast Fritz Muller GmbH & Co KG		8712759040726	8712759040726	8712759040726	8712759041679
81	106004	Coroplast AWX celband 9x3 mm wit - 10x25 m folie	10093 - Coroplast Fritz Muller GmbH & Co KG		8712759040764	8712759040764	8712759040764	8712759041693
82	106005	Coroplast AWX celband 9x3 mm zwart - 10x25 m folie	10093 - Coroplast Fritz Muller GmbH & Co KG		8712759040788	8712759040788	8712759040788	8712759041723
83	106006	Coroplast AWX celband 9x4 mm wit - 10x20 m folie	10093 - Coroplast Fritz Muller GmbH & Co KG		8712759040825	8712759040825	8712759040825	8712759041747
84	106007	Coroplast AWX celband 9x4 mm zwart - 10x20 m folie	10093 - Coroplast Fritz Muller GmbH & Co KG		8712759040849	8712759040849	8712759040849	8712759041761
85	107000	Coroplast AWX celband 9x2 mm wit - 10x25 m karton	10093 - Coroplast Fritz Muller GmbH & Co KG		8712759040719	8712759040719	8712759040719	8712759041662
86	107001	Coroplast AWX celband 9x2 mm zwart - 10x25 m karton	10093 - Coroplast Fritz Muller GmbH & Co KG		8712759040733	8712759040733	8712759040733	8712759041686
87	107002	Coroplast AWX celband 9x3 mm wit - 10x25 m karton	10093 - Coroplast Fritz Muller GmbH & Co KG		8712759040771	8712759040771	8712759040771	8712759041716
88	107003	Coroplast AWX celband 9x3 mm zwart - 10x25 m karton	10093 - Coroplast Fritz Muller GmbH & Co KG		8712759040795	8712759040795	8712759040795	8712759041730
89	107004	Coroplast AWX celband 9x4 mm wit - 10x20 m karton	10093 - Coroplast Fritz Muller GmbH & Co KG		8712759040832	8712759040832	8712759040832	8712759041754
90	107005	Coroplast AWX celband 9x4 mm zwart - 10x20 m karton	10093 - Coroplast Fritz Muller GmbH & Co KG		8712759040856	8712759040856	8712759040856	8712759041778
91	107100	Coroplast 4132 1000x2 mm white - 400 m	10093 - Coroplast Fritz Muller GmbH & Co KG		8712759078361	8712759078361	8712759078361
92	107101	Coroplast 4132 1000x2 mm anthracite - 400 m	10093 - Coroplast Fritz Muller GmbH & Co KG		8712759078408	8712759078408	8712759078408
93	107102	Coroplast 4133 1000x3 mm logroll white - 300 m	10093 - Coroplast Fritz Muller GmbH & Co KG		8712759078385	8712759078385	8712759078385
94	107103	Coroplast 4133 1000x3 mm logroll anthracite - 300 m	10093 - Coroplast Fritz Muller GmbH & Co KG		8712759078415	8712759078415	8712759078415
95	107104	Coroplast 4134 1000x4 mm logroll white - 200 m	10093 - Coroplast Fritz Muller GmbH & Co KG		8712759078392	8712759078392	8712759078392
96	107105	Coroplast 4134 1000x4 mm logroll anthracite - 200 m	10093 - Coroplast Fritz Muller GmbH & Co KG		8712759078422	8712759078422	8712759078422
97	107106	Coroplast 4202 F 1000x2 mm white - 200 m	10093 - Coroplast Fritz Muller GmbH & Co KG		8712759078439	8712759078439	8712759078439
98	107107	Coroplast 4202 F 1000x2 mm anthracite - 200 m	10093 - Coroplast Fritz Muller GmbH & Co KG		8712759078446	8712759078446	8712759078446
99	107108	Coroplast 4203 F 1000x3 mm white - 150 m	10093 - Coroplast Fritz Muller GmbH & Co KG		8712759078453	8712759078453	8712759078453
100	107109	Coroplast 4203 F 1000x3 mm anthracite - 150 m	10093 - Coroplast Fritz Muller GmbH & Co KG		8712759078460	8712759078460	8712759078460
101	107110	Coroplast 4204 F 1000x4 mm white - 100 m	10093 - Coroplast Fritz Muller GmbH & Co KG		8712759078477	8712759078477	8712759078477
102	107111	Coroplast 4204 F 1000x4 mm anthracite - 100 m	10093 - Coroplast Fritz Muller GmbH & Co KG		8712759078484	8712759078484	8712759078484
103	107112	Coroplast 4133 50x3 mm wit - 25 m	10200 - Piotec Klebetechnik GmbH		8712759078729	8712759078729	8712759078729	8712759078736
104	107113	Coroplast 4133 60x3 mm wit - 25 m	10200 - Piotec Klebetechnik GmbH		8712759078743	8712759078743	8712759078743	8712759078750
105	107114	Coroplast 4133 80x3 mm wit - 25 m	10200 - Piotec Klebetechnik GmbH		8712759078767	8712759078767	8712759078767	8712759078774
106	107115	Coroplast 4133 100x3 mm wit - 25 m	10200 - Piotec Klebetechnik GmbH		8712759078781	8712759078781	8712759078781	8712759078798
107	107116	Coroplast 4133 180x3 mm wit - 25 m	10200 - Piotec Klebetechnik GmbH		8712759078804	8712759078804	8712759078804	8712759078811
108	108000	Kohler celband 9x2 mm grijs - 100 m	10155 - Celdex B.V.		8712759016004	8712759036743	8712759036743	8712759036750
109	108001	Kohler celband 9x2 mm wit - 100 m	10155 - Celdex B.V.		8712759017001	8712759017001	8712759017001	8712759017056
110	108002	Kohler celband 9x3 mm grijs - 100 m	10155 - Celdex B.V.		8712759016103	8712759016103	8712759016103	8712759016158
111	108003	Kohler celband 9x3 mm grijs - 250 m	10155 - Celdex B.V.		8712759028106	8712759028106	8712759028106	8712759028151
112	108004	Kohler celband 9x3 mm wit - 100 m	10155 - Celdex B.V.		8712759017100	8712759017100	8712759017100	8712759017155
113	108005	Kohler celband 9x3 mm wit - 250 m	10155 - Celdex B.V.		8712759029103	8712759029103	8712759029103	8712759029158
114	108006	Kohler celband 9x4 mm grijs - 100 m	10155 - Celdex B.V.		8712759018107	8712759018107	8712759018107	8712759018152
115	108007	Kohler celband 9x4 mm grijs - 200 m	10155 - Celdex B.V.		8712759028205	8712759028205	8712759028205	8712759028250
116	108008	Kohler celband 9x4 mm wit - 100 m	10155 - Celdex B.V.		8712759019104	8712759019104	8712759019104	8712759019159
117	108009	Kohler celband 9x4 mm wit - 200 m	10155 - Celdex B.V.		8712759029202	8712759029202	8712759029202	8712759029257
118	108010	Kohler celband zonder folie 9x4 mm zwart - 5x20 m	10200 - Piotec Klebetechnik GmbH		8712759069185	8712759069185	8712759069185
119	108011	Kohler celband zonder folie 9x4 mm zwart - 5 m	10027 - Vito GmbH			8712759069192	8712759069192
120	108012	Kohler celband zonder folie 17x4 mm grijs - 25 m	10200 - Piotec Klebetechnik GmbH			8712759075575	8712759075575
121	108013	Kohler celband zonder folie 32x4 mm grijs - 25 m	10200 - Piotec Klebetechnik GmbH			108013
122	108014	Kohler celband 9x1 mm wit - 450 m	10200 - Piotec Klebetechnik GmbH		8712759077623	8712759077623	8712759077623	8712759077630
123	108015	Kohler celband 9x1 mm grijs - 450 m	10200 - Piotec Klebetechnik GmbH		8712759077647	8712759077647	8712759077647	8712759077654
124	108050	Kowo AWX celband 9x3 mm wit - 10x10 m	10200 - Piotec Klebetechnik GmbH		8712759073366	8712759073366	8712759073366	8712759073373
125	108051	Kowo AWX celband 9x3 zwart - 10x10 m	10200 - Piotec Klebetechnik GmbH		8712759073380	8712759073380	8712759073380	8712759073397
126	108052	Kowo AWX celband 9x4 wit - 10x10 m	10200 - Piotec Klebetechnik GmbH		8712759073403	8712759073403	8712759073403	8712759073410
127	108053	Kowo AWX celband 9x4 zwart - 10x10 m	10200 - Piotec Klebetechnik GmbH		8712759073427	8712759073427	8712759073427	8712759073434
128	108054	Kowo AWX celband 9x3 wit - 100 m	10200 - Piotec Klebetechnik GmbH		8712759078934	8712759078934	8712759078934	8712759078941
129	108055	Kowo AWX celband 9x3 zwart - 100 m	10200 - Piotec Klebetechnik GmbH		8712759078958	8712759078958	8712759078958	8712759078965
130	108056	Kowo AWX celband 9x4 wit - 100 m	10200 - Piotec Klebetechnik GmbH		8712759078972	8712759078972	8712759078972	8712759078989
131	108057	Kowo AWX celband 9x4 zwart - 100 m	10200 - Piotec Klebetechnik GmbH		8712759078996	8712759078996	8712759078996	8712759079009
132	109000	PE celband P 20x3 mm grijs - 100 m	10315 - Pilzecker's Industrie BV		8712759072215	8712759072215	8712759072215
133	109001	PE celband P 20x4 mm grijs - 100 m	10315 - Pilzecker's Industrie BV		8712759055058	8712759055058	8712759055058
134	109002	PE celband P 20x5 mm grijs - 75 m	10315 - Pilzecker's Industrie BV		8712759055041	8712759055041	8712759055041
135	109003	PE celband P 9x2 mm wit - 400 m	10315 - Pilzecker's Industrie BV		8712759069215	8712759069215	8712759069215
136	109004	PE celband P 20x4 mm grijs - 5x20 m	10315 - Pilzecker's Industrie BV		8712759055065	8712759055065	8712759055065
137	109005	PE celband quick 20x4 mm grijs - 5x20 m	10200 - Piotec Klebetechnik GmbH			109005
138	109500	PE celband 17x3 mm zwart - 20 m	10200 - Piotec Klebetechnik GmbH		8712759067570	8712759067570	8712759067570	8712759067587
139	109501	PE celband 32x3 mm zwart - 20 m	10200 - Piotec Klebetechnik GmbH		8712759067594	8712759067594	8712759067594	8712759067600
140	110000	Vawa Glasfix 9x3 mm wit - 10x25 m	10200 - Piotec Klebetechnik GmbH		8712759061455	8712759061455	8712759061455	8712759061462
141	110001	Vawa Glasfix 9x3 mm zwart - 10x25 m	10200 - Piotec Klebetechnik GmbH		8712759061479	8712759061479	8712759061479	8712759061486
142	110002	Vawa Glasfix 9x4 mm wit - 10x20 m	10200 - Piotec Klebetechnik GmbH		8712759061493	8712759061493	8712759061493	8712759061509
143	110003	Vawa Glasfix 9x4 mm zwart - 10 x 20 m	10200 - Piotec Klebetechnik GmbH		8712759061530	8712759061530	8712759061530	8712759061547
144	110006	Vawa Glasfix 9x4 mm wit - 10x10 m	10200 - Piotec Klebetechnik GmbH			GLASFIX
145	110007	Vawa Glasfix 9x4 mm zwart - 10x10 m	10200 - Piotec Klebetechnik GmbH			110007
146	111000	Zwaluw PE celband 9x2 mm grijs - 600 m	10238 - Vawa Nederland B.V.			8711595014366	8711595014366
147	111001	Zwaluw PE celband 9x2 mm wit - 600 m	10238 - Vawa Nederland B.V.			8711595049009	8711595049009
148	111002	Zwaluw PE celband 9x3 mm grijs - 400 m	10238 - Vawa Nederland B.V.			8711595014373	8711595014373	8711595150859
149	111003	Zwaluw PE celband 9x3 mm wit - 100 m	10238 - Vawa Nederland B.V.			8712759070662	8712759070662
150	111004	Zwaluw PE celband 9x3 mm wit - 400 m	10238 - Vawa Nederland B.V.			8711595041089	8711595041089	8711595150842
151	111005	Zwaluw PE celband 9x4 mm grijs - 275 m	10238 - Vawa Nederland B.V.			8711595014380	8711595014380	8711595150873
152	111006	Zwaluw PE celband 9x4 mm wit - 275 m	10238 - Vawa Nederland B.V.			8711595041157	8711595041157	8711595150866
153	112000	PE 15x3 mm antraciet dzk fijncellig - 25 m	10179 - EKI B.V.		8712759069239	8712759069239	8712759069239
154	112001	PE 45x4 mm antraciet dzk fijncellig - 20 m	10179 - EKI B.V.			112001
155	112002	PE 15x4 mm antraciet dzk fijncellig - 20 m	10179 - EKI B.V.		8712759057168	8712759057168	8712759057168
156	112003	PE 10x2 mm wit dzk - 25 m	10179 - EKI B.V.		8712759069253	8712759069253	8712759069253
157	112004	PE 10x4 mm wit dzk - 20 m	10179 - EKI B.V.			112004
GTIN

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
H:H	Cell Value	duplicates	text	NO
H:H	Cell Value	duplicates	text	NO
G:G	Cell Value	duplicates	text	NO
F:F	Cell Value	duplicates	text	NO
E:E	Cell Value	duplicates	text	NO

 

[mumps]

The problem is being caused by the blank cells in columns E to G. The macro recognizes the blanks as not being equal to the other values in the same row. How do you want to handle the rows that have one or more blank cells in E:G?

 

[Romano_odK]

The problem is being caused by the blank cells in columns E to G. The macro recognizes the blanks as not being equal to the other values in the same row. How do you want to handle the rows that have one or more blank cells in E:G?

Say in row 23 or 155, there are values that look the same in all three columns, why is it happening there also. If a cell is empty it suppose to light up red so that is ok, because there is a difference between them all, I only don't get it why its also happening when there is a value in all of them. Do you?