Fill matching cell value with a yellow background color

[Moonbeam111]

Hi all,

I have names that stretch from T1 to W28 (1 name per cell). I also have a name in cell C3 that I pick from a drop down list that corresponds to those names in cells T1 to W28.

What I'm trying to achieve is this: When I select a name from the drop down list in cell C3. I would like the vba function to look for the name that I selected from cell C3 and match it to the same name that is somewhere within T1 to W28 and fill it with a yellow background color.

I've tried a few codes but its not working. This is all basically so I know which names have already been selected from the drop down list so I don't select them again. Any help would be greatly appreciated.

 

[DanteAmor]

In the events of your sheet put the following:

Private Sub Worksheet_Change(ByVal Target As Range)
  If Target.Address = "$C$3" Then
    Dim f As Range
    Set f = Range("T1:W28").Find(Target.Value, , xlValues, xlWhole, , , False)
    If Not f Is Nothing Then
      f.Interior.Color = vbYellow
    End If
  End If
End Sub

Note Sheet Event:
Right click the tab of the sheet you want this to work, select view code and paste the code into the window that opens up.


----- --
Let me know the result and I'll get back to you as soon as I can.
Sincerely
Dante Amor
----- --

 

[Moonbeam111]

Wow works like a charm. Thank you very much!