IF THEN Formula

I need assistance creating a formula that will populate the GE BATCH# field from another worksheet if the TRACKING ID# is the same as shown. Then I would create conditional formatting for the cells t...