Hi,
There are 2 excel workbooks. The 1st workbook values are standard and 2nd workbook has dynamic values. We need to compare the 1st workbook 1st row data with 2nd workbook 1st row only and 2nd row in 1st workbook with 2nd row in 2nd workbook and so on. If the 1st row value in the 1st workbook not matches with 1st row in the 2nd workbook then we need to highlight that cell with a colour and 2nd row value in the 1st workbook not matches with the 2nd row in the 2nd workbook then we need to highlight that cell with a colour and so on.
Can any one suggest soloution for this.
Regards,
Raju