Flashing Text In A Cell

[nicelad_uk]

Hello,

This might sound daft, but im just wondering if it is possible to Flash text 2 different colours in a cell.

Cell A1 will say - - - Well done
and I want it to flash blue and red, but not use VBA to do it.

Can it be done or am I wishful thinking? This would be on Office 97.

Thanks

[StephenR]

I very much doubt you can do it without VBA.

[Badger101]

Only way I can think of would be to use conditional formatting based upon the second of the time. Normally use the mod 2 to alternate the color. Only issues then is with calculation.

[nicelad_uk]

Only way I can think of would be to use conditional formatting based upon the second of the time. Normally use the mod 2 to alternate the color. Only issues then is with calculation.

Thanks, I dont suppose you could give an exaple could you? Im not sure exactly what you mean.

[Andy Pope]

VBA solution only.
Blinking text

But I strongly advise against it.

[StephenR]

Prompted by Badger's suggestion, this is the closest I could get but it's hardly flashing and only seems to update if you refresh or select the cell. Perhaps it can be improved upon
CF formula is:

=MOD(SECOND(NOW()),2)=0

and change the text colour.

[royUK]

You can do it with VBA.

Option Explicit 
 
Public RunWhen As Double 
 
Sub StartBlink() 
    If Range("k8").Interior.ColorIndex = 3 Then 
        Range("k8").Interior.ColorIndex = 6 
    Else 
        Range("k8").Interior.ColorIndex = 3 
    End If 
    RunWhen = Now + TimeSerial(0, 0, 1) 
    Application.OnTime RunWhen, "StartBlink", , True 
End Sub 
 
Sub StopBlink() 
    Range("k8").Interior.ColorIndex = xlAutomatic 
    Application.OnTime RunWhen, "StartBlink", , False 
End Sub