Thank you for the welcome!
Let me see if I can post some pictures or clarification, because what you said to do just messed up the list I had or I'm just not understanding. Thank you for being patient!
so on List 1, cells A3:A10 look like this:
A B C
00117 Brad...
Here is my issue. I have a list of student names on one excel sheet, and I have to input names on another list. What my boss would like is to highlight the names on the 1st list if they show up on the 2nd list.
FYI - The fist list is static. The second list would be updated daily. Would a...