Help to compare two sheets

[nhnn1986]

Hi all
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
Conditions that:
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

How can I do that by VBA code

Thanks./.

Sheet (A)

A	B	C	D
A000-201808-56000-123	1011	100000	...
B001-201807-56001-123	1012	150000	...
A001-201807-56004-123	4501	200000	...
...	...	...	...

<tbody>
</tbody>

Sheet(B)

A	B	C	D
B001-201808-56000-123456	100
B001-201808-56000-123456	150

<tbody>
</tbody>

 

[nhnn1986]

Plz help me./.

 

[nhnn1986]

Some bode plz help