HI,
Can anyone help me on this Sheet. As from the Picture ...

I need to look colB and colC should be equal to colH and colI, IF both cells matched, then copy the EmpNo(ColB or colH) and Counter(colC or colI) get the difference of values in another colomn

If there is any row for Employee or Counter issing from either of tables populate with RED in either of 2 colomns,

for example:at row 17, table 1 has a missing colC, and row 17(table1) = row18(table2), it should populate the row17 for table2, as a reference.
excel.png