Validating values of a column from one excel with values from another excel

Hi All,

I am working on an interesting problem wherein i have 2 excel sheets with one common column(Name in the images below) in both the excel sheets as shown in the images below



Now i need to check from the first excel whether the values of name column are there in the second column or not, if the value is there in the 2nd excel sheet highlight the value in the first excel sheet with green color and if not with red color as from our images above i have highlighted


Please check the examples Xaml and Test.xlsx provided for you, if it helps, please mark as resolved.
Main.xaml (17.9 KB)
Test.xlsx (11.4 KB)

1 Like

Hi @WangJidong

Your solution works, just that there is more dimension to my problem which i forgot to add in the description without which your solution is kind of incomplete.
Actually the dt1 values are not continuous(Name column) like shown below(The third row was empty and so your solution marks it as red which i don’t want it should remain neutral)




Try this.
Main (1).xaml (18.0 KB)

1 Like

Hi @WangJidong

Thanks this solution works for me.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.