M
Mr.Param
Hi,
currently I am using this command:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Cells.Interior.ColorIndex = xlColorIndexNone
Target.EntireRow.Interior.ColorIndex = 36
End Sub
I would like to:
1. highlight only certain range e.g A2:AK81
2. highlighted cell change with different color
3. keep my shading color
TQ
currently I am using this command:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Cells.Interior.ColorIndex = xlColorIndexNone
Target.EntireRow.Interior.ColorIndex = 36
End Sub
I would like to:
1. highlight only certain range e.g A2:AK81
2. highlighted cell change with different color
3. keep my shading color
TQ