This is what i have.
Private Sub color1()
End Sub
Private Sub Worksheet_Change(ByVal Target As Range)
If Range("K10").Value = "true" Then
Range("B10:H10").Select
With Selection.Interior
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
.ThemeColor = xlThemeColorLight2
.TintAndShade = 0.599993896298105
.PatternTintAndShade = 0
End With
End If
End Sub
can someone please help me
Bookmarks