Complete an action based on matching data in another sheet
I would like to create a formula that will complete an action in one sheet if it see duplicate data in another. For example I have sheet One and sheet Two. If both contain the same name in the [Name] column. I would like to indicate that somehow in sheet #1 either by highlighting a row or using a flag or symbol or even just highlighting the row with a color in some fashion.