Hello

I want to Highlight Column When Cell Selected Without Removing the Sheets Other Background Colours in the sheet.

The code is am using is: 

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If Target.Cells.Count > 1 Then Exit Sub
    Application.ScreenUpdating = False
    ' Clear the color of all the cells
    Cells.Interior.ColorIndex = 0
    With Target
        ' Highlight the entire row and column that contain the active cell
       
        .EntireColumn.Interior.ColorIndex = 43
    End With
    Application.ScreenUpdating = True
End Sub
But it removed all my other background row colours, does anyone know how to stop that from happening?