I want to highlight/match between column C,D & K,L. but there is a catch. As you can see on Green marked area B&C ""13710 36"18"" (they are a pair) must match in the list of K,L ""13710 36"18"" column as a pair.


so Green marked pair C,D matches with K,L.


But in K,L there is another pair RED ""13710 44"18"" that doesnt match with any pair in C,D and RED ""13710 32"18"" C,D is not available in K,L


so i want to highlight those who matches as a pair. which pair doesnt match wont highlight (or highlight vice versa)


matching will be done between this four colums

Attached Images

TEST.png (81.4 KB, 22 views)

Attached Files

MATCH HIGHLIGHT.XLSX (32.6 KB, 6 views)