I am trying to get the text box to change background color when the percent is < 90.0% and > 110.0% and to change back when the value is in between. However it only does red in the current version below. When I change the "90.0" to "0.9" and so forth it will only work for number entered 0.9-1.1. I have tried many things but know I must be missing something.
Private Sub Grade_Exit(ByVal Cancel As MSForms.ReturnBoolean)
Grade.value = Format(Grade.value / 100, "0.0%")
Grade.value = Grade
If Grade < "90.0" Then
Grade.BackColor = &HFF&
ElseIf Grade > "110.0" Then
Grade.BackColor = &HFF&
ElseIf Grade >= "90.0" And Grade <= "110.0" Then
Grade.BackColor = CoreNumber.BackColor
End If
End Sub
Bookmarks