The titles a bit shaky, sorry if it makes no sense
Anyway, im trying to write a code (im pretty nood at excel so bare with me here) that when i put 'Y' (as in yes) into column F it fills that whole row with red or orange. thae code im using at the moment seems to have some end if issues.
it could just be a terrible code.
tl;dr When i put 'Y' into column x i want it to fill the row with red.
the (non working) code im using right now is
Anyway, im trying to write a code (im pretty nood at excel so bare with me here) that when i put 'Y' (as in yes) into column F it fills that whole row with red or orange. thae code im using at the moment seems to have some end if issues.
it could just be a terrible code.
tl;dr When i put 'Y' into column x i want it to fill the row with red.
the (non working) code im using right now is
Code:
Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)
If (Range("F:F").Value) = "Y" Then
Rows("Target.Offset(0, 1)").Select
With Selection.Interior
.ColorIndex = 46
.Pattern = xlSolid
End If
End With
End Sub