K kitty77 Registered User. Local time Today, 00:44 Joined May 27, 2019 Messages 719 Mar 2, 2023 #1 What is the best way to state this? If [sample] < 400 Or [sample] > 500 Then sample.ForeColor = vbRed Else sample.ForeColor = vbGreen
What is the best way to state this? If [sample] < 400 Or [sample] > 500 Then sample.ForeColor = vbRed Else sample.ForeColor = vbGreen
Minty AWF VIP Local time Today, 05:44 Joined Jul 26, 2013 Messages 10,691 Mar 2, 2023 #2 I think you have it about as simple as you can get it. Code: If [sample] < 400 Or [sample] > 500 Then sample.ForeColor = vbRed Else sample.ForeColor = vbGreen End If
I think you have it about as simple as you can get it. Code: If [sample] < 400 Or [sample] > 500 Then sample.ForeColor = vbRed Else sample.ForeColor = vbGreen End If
