Highlighting dependant on whats clicked ?

[Pauljj]

In the range of AG7:AG33 I have a list of locations.

I have the same list of locations in a different order in the range AL7:AL33

If for example the user selects cell AG7 which has the location Exeter in it and Exeter appears in AL15, I would want AL15 to be highlighted...does that make sense ????

 

[ColinKJ]

Hi Pauljj,

What sort of highlight do you mean, selected or coloured.

ColinKJ

 

[MickG]

Hi, Try:-

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim Rng As Range, Dn As Range
If Intersect(Target, Columns("AG")) Is Nothing Or Target.Count > 1 Then Exit Sub
    Set Rng = Range(Range("AL1"), Range("AL" & Rows.Count).End(xlUp))
        For Each Dn In Rng
            If Dn.Value = Target.Value Then
                Dn.Interior.ColorIndex = 34
            End If
        Next Dn
    End Sub

Regards Mick

 

[Pauljj]

This is perfect, thanks for this. Is there any way I can restrict this to only rows 7 to 33 ??

 

[Pauljj]

Please ignore as I have just worked my own question out. Thanks for your help