I have some basic code below to automatically highlight a row a predetermined cell color after a double click. How do I modify this code to also change the font to bold white?
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Cancel = True
If Target.Interior.ColorIndex = xlNone Then
Target.EntireRow.Interior.ColorIndex = 15
Else
Target.EntireRow.Interior.ColorIndex = xlNone
End If
End Sub
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Cancel = True
If Target.Interior.ColorIndex = xlNone Then
Target.EntireRow.Interior.ColorIndex = 15
Else
Target.EntireRow.Interior.ColorIndex = xlNone
End If
End Sub