I need for users to insert yes / no into column C. If no, the next cell should display N/A and fill in as grey. If yes, the next cell should be highlighted as yellow and allow users to fill in that cell.
The code is below, but if a cell has no and then is changed to yes the next cell over doesn't change from N/A to highlighted.
Private Sub Worksheet_Change(ByVal Target As Range) Dim Cell As Range If Target.Column = 3 Then Set Cell = Target.Offset(0, 1) If Len(Target.Value) = 0 Then Cell.Validation.Delete Cell.Value = vbNullString Else If Target.Value = "Yes" Then With Cell.Validation Cell.Interior.ColorIndex = 36 End With ElseIf Target.Value = "No" Then Cell.Validation.Delete Cell.Value = "N/A" Else MsgBox "Input only Yes or No." Target.ClearContents Cell.Validation.Delete End If End If End If End Sub