PDA

View Full Version : Solved: Whole row becomes shaded / highlighted when selected



BENSON
04-12-2007, 10:56 PM
Can Malcoms code seen below from a previous post be altered to also shade/ highlight the entire row say light grey


Option Explicit
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Cells.Font.Bold = False
Target.EntireRow.Font.Bold = True
End Sub

THKS

geekgirlau
04-12-2007, 11:25 PM
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Cells.Font.Bold = False
Target.EntireRow.Font.Bold = True
Target.EntireRow.Interior.ColorIndex = 15
End Sub

BENSON
04-12-2007, 11:29 PM
MANY THANKS

Bob Phillips
04-13-2007, 01:20 AM
Don't forget to clear last time


Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Cells.Interior.ColorIndex = xlColorIndexNone
Cells.Font.Bold = False
Target.EntireRow.Font.Bold = True
Target.EntireRow.Interior.ColorIndex = 15
End Sub