If a value has been selected in column G and then the value in column D changes, you will still need either a manual interaction or a macro to change column G to "no" when column D changes to "no". Let me know if you want to pursue that.
Private Sub Worksheet_Change(ByVal Target As Range)
Dim cel As Range
If Not Intersect(Target, Range("D:D")) Is Nothing Then
For Each cel In Target
If UCase(cel.Value) = "NO" Then cel.Offset(0, 3) = "No"
Select allOpen in new window
© 1996-2022 Experts Exchange, LLC. All rights reserved. Covered by US Patent