Can anyone please suggest how can we compare two datatables row by row and highlight differences in 1st excel sheets
Yes we can compare 2 dts row by row.
view on this thread
Please provide sample input data and expected output in excel sheet. That will help us to give exact solution.
Excel 1 and Excel 2 , need to compare these two files and highlight records in Excel 1
Check this out:
Excel highlight compare.xaml (9.4 KB)