Conditional formatting, Vlookup or IF statement

Hi Guys, I've been stuck on something for a while, hoping somebody can help. I seem to have lost it but would really appreciate some help. I'll try to explain as best as I can.

I have 2 sets of data on 2 separate tabs. For instance.

Tab1: Name | InHere | Exempt | NotHere
Tab2: Name | InHere| Exempt | NotHere

InHere/Exempt/NotHere can either be 1 or 0, signifying the attendance.

I filtered Tab1 with everybody who is NotHere (1=NotHere) back in 2017. In an attempt to move everybody from NotHere 1 to Inhere 1 or Exempt 1. Unfortunately only approx. 5% transpired.

I now have data 2018 data on tab 2 which includes a load of other names + all the names in Tab1.
I would simply like to check all those NotHere in tab 1 (NotHere=1 / Exempt=0 / InHere=0), which of them are now InHere or Exempt in Tab2 (NotHere=0 / Exempt=1 OR InHere=1) . And Highlight the ones that are still NotHere.

I apologise if I am not good at explaining this, but I have tried as best as I could. Really would appreciate if somebody could help how to best run this logic.
Happy to elaborate if need be.

THanks so much in advance, Im using the latest version of excel