Comparing 6 coloumn and highlighting the difference

[sachin483]

i have concatenated the 6 column and compared with other 6 column, but how can highlight the difference , i don't want to compare each column i want to compared after concatenating only

COL1

COL2

COL3

COL4

COL5

COL6

COL1

COL2

COL3

COL4

COL5

COL6

RA

100ZR

100RR

100AR

200TR

1

RA

100ZR

100RR

100AR

200TR

1

RA

100ZR

100RR

100AR

100TR

2

RA

100ZR

300RR

100AR

100TR

2

RA

100ZR

100RR

100AR

200TR

1

RA

100ZR

300RR

100AR

200TR

1

RA

100ZR

100RR

100AR

300TR

1

RA

100ZR

300RR

200AR

300TR

1

RA

100ZR

100RR

100AR

400TR

1

RA

100ZR

300RR

100AR

400TR

1

RA

200ZR

100RR

100AR

500TR

1

RA

100ZR

300RR

100AR

500TR

1

RA

100ZR

100RR

100AR

200TR

1

RA

100ZR

100RR

100AR

200TR

1

RA

100ZR

100RR

100AR

610TR

1

RA

100ZR

300RR

100AR

710TR

1

RA

100ZR

100RR

100AR

910TR

1

RA

100ZR

300RR

100AR

910TR

1

RA

100ZR

400RR

400AR

010TR

2

RA

100ZR

300RR

400AR

010TR

1

RA

100ZR

100RR

100AR

200TR

1

RA

100ZR

100RR

100AR

200TR

1

RA

100ZR

100RR

100AR

200TR

1

RA

100ZR

100RR

100AR

200TR

1

<colgroup><col><col><col><col><col><col><col><col><col><col span="2"><col><col></colgroup><tbody>
</tbody>

 

[admiral100]

Hi,

In M2 enter
=EXACT(CONCATENATE(M2,L2,K2,J2,I2,H2),CONCATENATE(F2,E2,D2,C2,B2,A2))

Then go to conditional formatting , select =$A$2:$N$13
and enter the formula =$N2=FALSE

 

[sachin483]

All the columns in the row are getting highlighted but i wanted the particular column where there is a mismatch ca it be done with a VBA