Clear Cell Contents Based on Value in Another Cell

[ExcelSuduko]

I looked at a couple of similar threads but still could not get this to work. I have a YES/NO drop-down box in column "C" of my workbook. The drop-down uses a data validation list

If "No" is selected, then everything in columns D-M, in the same row, needs to be cleared from the row. My range is B4 to M100, so this ability needs to be applicable to every row, based on the corresponding No response in column C. If "yes", then what is in the row will remain.

Thank you.

 

[Fluff]

How about

Private Sub Worksheet_Change(ByVal Target As Range)
   If Target.CountLarge > 1 Then Exit Sub
   If Not Intersect(Target, Range("C4:C100")) Is Nothing Then
      If Target.Value = "No" Then Target.Offset(, 1).Resize(, 10).Value = ""
   End If
End Sub

This needs to go in the relevant sheet module.

 

[ExcelSuduko]

Yes, that worked!
Thank you!!

 

[Fluff]

You're welcome & thanks for the feedback.