Conditional formatting based on neighboring cell

Hi.  I'm looking for some help figuring out what the best way to go about this is.  I've got a sign-in sheet to keep track of guests that are in a building.  One column is a list of the guests names,...