flash a range if a value is present

[still learning]

Hi
I got help with a macro to flash a cell if a string was present due to an If statement, from HERE. Thank you very much!!!!
I'm trying to modify it to flash a cell with a value instead of a string
When "Balance1" is = to or less than 100, I want "Balance" to flash a couple of times. "balance" is the result of an If statement

Sub flash()
Dim i As Long
If Range("Balance1").Value = "<=100" Then
            Application.EnableEvents = False
            With Range("balancee")
                For i = 1 To 1
                    .Font.ColorIndex = 2
                    Application.Wait (Now + TimeValue("00:00:01"))
                    .Font.ColorIndex = 3
                    Application.Wait (Now + TimeValue("00:00:01"))
                Next i
            End With
            Application.EnableEvents = True
        End If
End Sub

mike

 

[Joe4]

Change this line:

If Range("Balance1").Value = "<=100" Then

to this:

If Range("Balance1").Value <=100 Then

 

[Craggs82]

nice easy one to start the weekend! As long as the value is a number changing the criteria line to this should work. You don't want the quotation marks unless you're working with strings or in some formulas.

If Range("Balance1").Value <= 100 Then