Table differences

Hi,

I want the list of differences between the two table files to be listed in the other file and I want the master tables to be highlighted in two different colors for differences less than or equal to 1 (orange) and differences more than 1 (yellow). Please find the attached files for an example of how I need it. Previously I got the below mentioned code from this forum but I wanted few more things in a similar fashion.

1. Coloring
2. Finding differences from two different files (previously it was done within the file).
2. If there are any words which are different between the two tables, I get a error message (I only want the values and words needs to be skipped).

Please Login or Register  to view this content.

Thanks,
Yathish D

Table 1.xlsxTable 2.xlsxTable difference.xlsm