Hi guys,

I'm a bit of a novice Excel user, and I'm trying to do something that I think is quite simple, and am finding it quite hard.

One of the columns (G) in my spreadsheet is a list of colleagues names... What I want to do is compare them to a smaller list of peoples names (that is on sheet 2) and if there are any matches, I want them to be shown in red across the entire row where that match occurred... Is this possible?

Thanks in advance.