I have defined a list in a table that contains a couple hundred names
(database). I have another sheet with a shorter list (entry). I would like to
be able to type names into that list and have the matching entry in the
database have it's formatting change. I'm able to get the corresponding
index, but I'm not sure how to change the formatting on another sheet. Here's
what I have so far on the entry sheet:

<SNIP
Private Sub Worksheet_Change(ByVal rangeTarget As Range)
If Intersect(rangeTarget, Range("listDraftPlayerNames")) Is Nothing Then
Exit Sub
If rangeTarget = 0 Then Exit Sub
' Declare some variables.
Dim dMatchIndex As Double
' Find the index to the list that matches the target exactly.
dMatchIndex = Application.WorksheetFunction.Match(rangeTarget,
Sheet3.Range("listRankyahooPlayerNames"), 0)
End Sub
</SNIP

If you haven't noticed, this is for a fantasy football draft. As the draft
progresses I plan on entering drafted players and I'd like them to disspear
to get crossed out on the databases so I know I cannot pick them.

Thanks.