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
