
Will try your updated version tomorrow, you’re right through I don’t fully understand BA or VBA and the code is mostly hashed together from other suggestions
- Code: Select all
With Target.Parent
If .Range("D2").Value <= TimeValue("00:05:00") And .Range("K1").Value <> "FO" Then
.Range("Q2").Value = "FULL-STREAM-ON"
ElseIf .Range("D2").Value >= TimeValue("00:05:00") And .Range("K1").Value = "FO" Then
.Range("Q2").Value = "FULL-STREAM-OFF"
End If
End With