I have two sheet(A) and sheets(B), now I want to compare with three conditions and color row(j) in sheet(B) if wrong
1. Mid(sheet(A).row(i) = Mid(sheet(B).row(j)= "201808-5600"
2. Sheet(A).row(i,2) = "1011"
3. Sheet(A).row(i,3).value/1000 = Sheet(B).row(j,2).value