'Refreshing Color of Cell when New Data is entered

I'm trying to write this function which reads the value of a combo box then finds the range using an if statement, and then changes the background color of the cell based on the number entered and the conditions. Currently, it is not refreshing when a new number is entered by the user. Any help would be appreciated. Thank you. enter image description here

Private Sub Worksheet_Input_Verification(ByVal Target As Range)

    If ComboBox1.Value = "200: 72 VDC w/120 VAC input power" Then
        If Range("C10").Value < 12 Or Range("C10").Value > 24 Then
            Range("C10").Interior.ColorIndex = 3
        ElseIf Range("C10").Value > 12 Or Range("C10").Value < 24 Then
            Range("C10").Interior.ColorIndex = 4
        End If
    End If

End Sub

excel vba

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source

'Refreshing Color of Cell when New Data is entered

Sources

Related Questions