I have 2 excel files. There are 10 columns in each file. Columns in file 1 and file 2 are the same but the data is slightly different. we need to find the differences.
Read the value in column A and compare the values of that row in file 1 and file 2 and highlight the cells which have different values.
Is it possible to compare the 2 files and highlight (color) the rows or cells with a difference?
Is it possible to reach to a solution with a vbscript?
Thanks in advance.