Put this code in the After Update event of the TextBox that holds your "yes" "no"
Private Sub YourTextBoxName_AfterUpdate() Const vbOrange = 4227327 If Me.YourTextBoxName.Value = "yes" Then Me.TheNameOfTheTextBoxThatChangesColour.BackColor = vbOrange Else Me.TheNameOfTheTextBoxThatChangesColour.Visible = False End If
It hasn't formatted it very well. Const should be on a new line, so should be the if statement. Else should also be on a new line together with the second Me statement. End If also on a new line. Sorry about that.