Find matches and highlight them

[tvining]

I would like to have a list of names in column C that when I click on them, would be highlighted in Column A and B.

A B C
1 1 1
2 3 2
5 2 3
4 4 4
3 5 5

So, when I go to Column C and click "3" then all the 3's in A or B are highlighted!

A B C
1 1 1
2 3 2
4 4 4
5 2 [3]<<CLICKED p HERE!<> selected this
3 5 5

Basically, it's a SCHEDULE. I want them to click their names, and see what day/shift they are working.

Tony

 

[VoG]

Try this. Right click the sheet tab, select View Code and paste in

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim c As Range
If Target.Count > 1 Then Exit Sub
Me.UsedRange.Cells.Font.ColorIndex = xlAutomatic
For Each c In Me.UsedRange
    If c.Value = Target.Value Then c.Font.ColorIndex = 3
Next c
End Sub

then close the code window using the X.

 

[tvining]

That's the greatest. Thank you very much!

 

[tvining]

If you don't mind me being greedy, how can I change both the foreground and background at the same time?, so when I click a name it shows with black background, white text?

Might as well go for the gusto.

Thanks

 

[VoG]

Try

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim c As Range
If Target.Count > 1 Then Exit Sub
With Me.UsedRange.Cells
    .Font.ColorIndex = xlAutomatic
    .Interior.ColorIndex = xlNone
End With
For Each c In Me.UsedRange
    If c.Value = Target.Value Then
        c.Font.ColorIndex = 2
        c.Interior.ColorIndex = 1
    End If
Next c
End Sub