Open the Visual Basic Editor (VBE) with Alt+F11 and double click on "ThisWorkbook" In the file you want to add the code to and paste this code in the main window.
Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)
Dim lngColor As Long
lngColor = RGB(250, 190, 105)
Dim i As Integer
Cells.Interior.ColorIndex = xlNone
For i = 1 To Target.Row
Cells(i, Target.Column).Interior.Color = lngColor
Next
For i = 1 To Target.Column
Cells(Target.Row, i).Interior.Color = lngColor
Next
End Sub
You can change the numbers after RGB( to change the color. Good Luck.
Bookmarks