Matching excel files with differences

Hi Gurus,

I have 2 formatted excel sheets with multiple equal tabs. I need to match them and highlight the differences.

I tried many macros which can match sheets just on plane data with no formatting at all column to column but formatted excel sheet matching is something different.

But I have below issue here with situations.

Impediments:
1- Excel file is GUI based formatted means multiple columns could be merged as single cell
2- graphical tables are present in excel sheet.
3-Difference highlighting can be in any way either coloring that cell which has difference or differences can be logged in other file whichever is easy part.



Please help....