If/Else If help to Change BackColor

[SpdRacerX]

So far I have figured out the following:

Private Sub High_Risk_Status_AfterUpdate()
If Me.[High-Risk.Status] = "Active" Then
Me.Section(acDetail).BackColor = 8421631 'Gray
Me.Auto_Title0.BackColor = 8421631 'Gray
Else
Me.Section(acDetail).BackColor = 12632256 'Red
Me.Auto_Title0.BackColor = 12632256 'Red
End If
End Sub

Private Sub Form_Current()
If Me.[High-Risk.Status] = "Active" Then
Me.Section(acDetail).BackColor = 8421631 'Gray
Me.Auto_Title0.BackColor = 8421631 'Gray
ElseIf Me.[Behavorial] = -1 Then
Me.Section(acDetail).BackColor = 8421631 'Gray
Me.Auto_Title0.BackColor = 8421631 'Gray
Else
Me.Section(acDetail).BackColor = 12632256 'Red
Me.Auto_Title0.BackColor = 12632256 'Red
End If
End Sub

Private Sub Behavorial_AfterUpdate()
If Me.[Behavorial] = -1 Then
Me.Section(acDetail).BackColor = 8421631 'Gray
Me.Auto_Title0.BackColor = 8421631 'Gray
Else
Me.Section(acDetail).BackColor = 12632256 'Red
Me.Auto_Title0.BackColor = 12632256 'Red
End If
End Sub

What I need is it to change the Back Color of the Title to Red if High-Risk = "Active", to Yellow if Behavorial = "Yes" and to leave it alone if none of the two criteria is met.

I've tried some combinations but I just can't seem to get it. Right now the code turns it Red if either are met.

Thank-you for any help.

[SpdRacerX]

Nevermind. I figured it out by making two different If Else statements rather than ElseIf.

[SpdRacerX]

Seems when I change the Behavorial to Yellow it doesn't work, it turns every record to Red. Am I missing something?