I will be honest, this is for a fanatsy league so bear with me please. There
are hundreds of player names that I show on one tab. On a second tab I show
who has picked which players. I have been manually going through the list of
players and coloring the box red when that player is chosen. Is there a
formula using 'Match' or something else that will automatically color the box
red when that players name is duplicated on another tab? Ex.

Tab 1 Tab 2
Players Roster
Joe John
Adam Hector
Bill Joe


I needs a formula that will turn the cell for joe in Tab 1 Red when
some one chooses Joe in Tab 2. Thanks for any help.