So this is in VBA right so my code would be something like this right?
Private Sub Form_Load()
If Company.Value = "COP" Then
Company.BackColor = vbRed
End If
End Sub
I'm still a little lost I guess, do I needing the "If...Then" Statement or is "Value is" it's own built in...