How to loop through rows and columns in two excel sheets, compare the values and highlight the mismatched one

[Iamnavsh (Naveen)]

Hello,

I have a scenario where I have to compare two excel sheets, row by row, column by column. If there is any mismatch, then that particular field should be highlighted as red(or any color). Can anyone help me out in this?

[kadiravan_kalidoss (Kadiravan K)]

Highlight_Unmatch_Values.zip (11.2 KB)

Thanks!

[Luis261980 (Luis Nunes)]

Hi @Iamnavsh,

For each Sheet in C:…xlsx
Use excel aplication and read range to create DT
and inside
For each row

Thats what i will do. GL

[redbee]

Hi @kadiravan_kalidoss,

Do you also have xaml example if there are multiple columns involved? For example, 40 columns. And, instead of highlighting the cell, a new row will be updated with Matched and Unmatched.