Conditional Formatting or Logical Test ot Vlookup and IF

[hiren57]

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, how many of them are actually InHere or Exempt as of 2018. 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.

 

[hiren57]

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.

Rephrased

 

[hiren57]

Pleasee help guys Re: Conditional Formatting or Logical Test ot Vlookup and IF

Rephrased

Please can somebody save my day and help me.