In a ThisWorkbook Module put:
Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, _
ByVal Target As Excel.Range)
On Error Resume Next
Sh.Cells.Interior.ColorIndex = xlColorIndexNone
Target.Interior.ColorIndex = 6 ' yellow - change as needed
End Sub
Is this what you mean?