Adding additional Conditions to Conditional Formatting

[mlgmlg]

Hello,

I have a text box (on a Single Form) that I use to color code milestones based on a value. I use the “Conditional Formatting” tool to format four of the conditions, which works great! Unfortunately, I need an additional two conditions for a total of six.

I believe the additional two conditions must be created by using code to accomplish what I need, but I do not have a whole lot of knowledge in coding. I am wondering if someone can assist me with creating the last two conditions.

I need a text box (txtbox_status) to turn “Green” when I enter the number “5” in the text box and “Pink” when I enter the number 6.

Appreciate any help I can get.

[puppydogbuddy]

I need a text box (txtbox_status) to turn “Green” when I enter the number “5” in the text box and “Pink” when I enter the number 6.

Private Sub txtbox_status_Change()

If Me.txtbox_status.Value = 5 Then
        Me.txtbox_status.BackColor = vbGreen
ElseIf Me.txtbox_status.Value = 6 Then
        Me.txtbox_status.BackColor = vbPink   ' <<try vbCyan or vbMagenta if pink not recognized
End If
End Sub