Forum Discussion
COMPARE DATE FROM DIFFERENT SHEETS
compare Table2 with Table1 data, highlight any difference in identification number for the same TT no in table1. TABEL 1 TT NO Identity number KA19AB4734 1073 KA19AB4734 T892 KA1...
As variant you may use conditional formatting rule with formula
=ISNA( IFNA(
XMATCH($F6&$G6,$C$5:$C$262&$D$5:$D$262),
XMATCH($F6&$H6,$C$5:$C$262&$D$5:$D$262)
) )The only proper to use references for your case, please see attached.