I have 2 worksheets, one is a list of towns that accepted an invitation, the other is a list of all towns invited and what county they are in. The first sheet uses a vlookup to add the county to a column next to the town name.
I would like the 2nd sheet to record ( by highlighting or fillling in the town name) the na,es of town who gave accepted invites so that we can quickly see who to follow, I'm thinking conditional formatting by formula but can fight out the formula.

