Hi Mcmugs, welcome to the forum.

You should be able to use conditional formatting for this, but I suggest uploading a sample file that contains data matching your actual data (use fake names/data to protect confidential information). In the sample, show where matches should occur and what you'd like to see as the result.