MrExcel Publishing
Your One Stop for Excel Tips & Solutions


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

Some kind of conditional formatting perhaps??


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