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!

Right click sheet tab>view 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
(E-Mail Removed)
"Reedhill" <(E-Mail Removed)> wrote in message
news:8D24A1F1-AD07-4E67-9CCC-(E-Mail Removed)...
> 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!

you may want to try Chip Pearson's Rowliner:
http://www.cpearson.com/excel/RowLiner.htm

Reedhill wrote:
>
> 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!

--

Dave Peterson

Thanks both of you. They worked fine.

"Reedhill" kirjoitti:

> 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!