Updated the Original File with ExcelForum Member Suggestion
I have updated the Original Excel Sample file as per ExcelForum Member suggestion and applied the following code.
Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)
Target.EntireColumn.Interior.ColorIndex = 8
Target.EntireRow.Interior.ColorIndex = 8
Target.Interior.ColorIndex = 7
End Sub
This code does solves the partial issue . i.e default background cell is highlighted. when we move from one cell to another cell. the previously highlighted cell is not cleared, Also while moving from once cell to another cell it over writes the exisiting background color.
What we need is,
While moving from one cell to another cell, the original color should be restored.
I hope I am able to explaining it correctly.
Thanks