Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Private Sub Worksheet_SelectionChange(ByVal rngSel As Range)
- Set rngTable = [I2:K17]
- If rngSel.Count > 1 Or Intersect(rngSel, rngTable) Is Nothing Then End
- For Each rngCell In rngTable
- rngCell.Interior.ColorIndex = IIf(rngCell.Value = rngSel.Value, 27, -4142)
- Next
- End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement