HOW TO 'BLINK' A FIGURE INSTEAD OFF BOLDING THE FIGURE
 

Text Effects - similar type in Word

HOW TO 'BLINK' A FIGURE INSTEAD OFF BOLDING THE FIGURE
 

Hi,

There is no feature like this in Excel.

FYI - this feature has been removed from Word in 2007.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Nad.Engoor" wrote:

Text Effects - similar type in Word

HOW TO 'BLINK' A FIGURE INSTEAD OFF BOLDING THE FIGURE
 

hi, Nad.Engoor !

Text Effects - similar type in Word

see: http://www.cpearson.com/excel/BlinkingText.aspx

or... there is a wise-tricky procedure (posted by KL in spanish ng sometime ago)...
(and with minor changes based on Thomas Jansen -1999- post)...
that let's you to preserve the undo-levels, and you might want to give it a try...

if any doubts (or further information)... would you please comment ?
hth,
hector.

assuming "the figure" is in B1 and you need it to flash if it's value is greater than 5

1) select [B1]... - (menu) format / conditional format...
formula: - =(b15)*(mod(second(now()),2)=0)
format: - apply formats as needed/wished/...

2) copy/paste the following lines:
===
a) in a general code module:
===
Option Private Module
Public Sequence As Date
Sub StartBlinking()
Sequence = Now + TimeSerial(0, 0, 1)
Worksheets(1).Range("b1").Calculate ' modify/adapt/... worksheet's index/name as appropriate
Application.OnTime Sequence, "StartBlinking"
End Sub
Sub StopBlinking()
On Error Resume Next
Application.OnTime Sequence, "StartBlinking", Schedule:=False
End Sub
===
b) in ThisWorkbook code module:
===
Private Sub Workbook_Open()
StartBlinking
End Sub
Private Sub Workbook_BeforeClose(Cancel As Boolean)
StopBlinking
End Sub

HOW TO 'BLINK' A FIGURE INSTEAD OFF BOLDING THE FIGURE
 

While you've been given a couple of ways of doing this, I *highly*
recommend that you NOT do it.

If you have government clients (in the US) that use your workbook, it
may even be illegal due to its ability to trigger epileptic seizures:

http://www.section508.gov/index.cfm?...ID=12#Software

besides, it's irritating as hell.

In article ,
Nad.Engoor wrote:

Text Effects - similar type in Word