I very much doubt you can do it without VBA.
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.
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.
www.imits.co.uk - for all your training and development needs!
VBA solution only.
But I strongly advise against it.
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:and change the text colour.=MOD(SECOND(NOW()),2)=0
You can do it with VBA.
VB: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
Hope that Helps
New users should read the Forum Rules before posting
For free Excel tools & articles visit my web site
If I have helped you and you feel like putting your hand in your pocket please make a donation to Children in Need
RoyUK's Web Site
royUK's Database Form
Where to paste code from the Forum
There are currently 1 users browsing this thread. (0 members and 1 guests)