I am using Excel 2013. I'm not really sure how to pose my question. I hope I don't confuse you. Here's what I want to do: I have a very large column of names and want to be able to type a name into a different cell, which, if it is in that column of names, would cause it to light up a different color. Is that possible? If so, how?