Right click sheet tabview code insert this
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
Cells.Interior.ColorIndex = 0
With ActiveCell
.EntireRow.Interior.ColorIndex = 36
.EntireColumn.Interior.ColorIndex = 36
End With
End Sub
--
Don Guillett
SalesAid Software
"Reedhill" wrote in message
...
Hi
Is there any way to get colours to the row and to the column where the
cursor is. They should change every time when moving the cursor. Thanks!