![]()
Private Sub Worksheet_Change(ByVal Target As Range) Application.EnableEvents = False If Target.Value <> "" Then If Not Intersect(Range("C3:C5"), Target) Is Nothing Then If Application.WorksheetFunction.CountIf(Range("C3:C5"), "Not Bought") > 0 Then Range("C2").Value = "Not Bought" Else Range("C2").Value = "Bought" End If ElseIf Target.Address = "$C$2" Then Range("C3:C5").Value = Target.Value End If End If Application.EnableEvents = True End Sub
Bookmarks