I am current using the blink text code found at www.cpearson.com but I would
like to make it so that if I were to change a value in a cell that it would
then start blinking. So for example: If cell A1:A100 percentages changes
between 75% to 100% than blink and if it is 100% over 100% than I need to
show some kind of different signals but I still want taht cell to be
blinking.
Also, I would like to make the cell's fill color blink from white to red and
not the text (this is not as crititcal). Any help on this would be great.
my e-mail is Here is coding that I have used

Public RunWhen As Double

Sub StartBlink()
If Range("bq6:bq89").Font.ColorIndex = 2 Then
Range("bq6:bq89").Font.ColorIndex = xlColorIndexAutomatic
Else
Range("bq6:bq89").Font.ColorIndex = 3
End If
RunWhen = Now + TimeSerial(0, 0, 1)
Application.OnTime RunWhen, "StartBlink", , True
End Sub


Sub StopBlink()
Range("bq6:bq89").Font.ColorIndex = xlColorIndexAutomatic
Application.OnTime RunWhen, "StartBlink", , False
End Sub

Thanks in advance!