Forgot to say to do this in your TAB1 Cell

"Danny" wrote:

Hi There,

Please try:

Go to Format
Choose conditional format

Condition 1: Formula is
=MATCH($B$3,$C:$C)

$B$3= referring to your TAB1 Cell
$C:$C= reffering to your TAB2 Cell

Then Click format
Click Patterns, and change the color you want.

"Riptide" wrote:

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.