MrExcel Publishing
Your One Stop for Excel Tips & Solutions

ActiveRow


Posted by Håkan Fagerström on November 01, 2001 12:10 AM

Is it possibe to change the color of the whole row
and column of the active cell?

Ex. Call C3 is activated >> Column C and Row 3 turns
blue...

Some kind of conditional formatting perhaps??

Thanx


Posted by Geoffrey Hurst on November 01, 2001 1:18 AM


No, an event procedure :-

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Cells.Interior.ColorIndex = xlNone
With ActiveCell
.EntireRow.Interior.ColorIndex = 5
.EntireColumn.Interior.ColorIndex = 5
End With
End Sub