Flashing Cells

[DT]

Can anyone help please?

Is it possible to make the contents of a cell flash when the value reaches a
certain level?

Many thanks for your help in anticipation.

DT

 

[Niek Otten]

Look here:

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

 

[Héctor Miguel]

hi, !

Is it possible to make the contents of a cell flash when the value reaches a certain level?

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

or... there is a wise-tricky procedure (posted by KL in spanish ng sometime ago)...
which (and with minor changes based on Thomas Jansen -1999- post)...
=> 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: -> =(b1>5)*(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

 

[Bernard Liengme]

I do hope the OP saw Chips warning at the end of his notes:
Blinking text may not be allowed in applications for governmental bodies,
since it may be in violation of Section 508 of the Rehabilitation Act Of
1973 (since blinking text can cause seizures in epileptic patients).

 

[Héctor Miguel]

hi, Sir !

Bernard Liengme wrote in message ...
I do hope the OP saw Chips warning at the end of his notes:
Blinking text may not be allowed in applications for governmental bodies,
since it may be in violation of Section 508 of the Rehabilitation Act Of 1973
(since blinking text can cause seizures in epileptic patients).

may I ask if a blinking text, handled by OnTime procedure
once every second (60 Hz), could it be disrupting that regulation ?

TIA,
hector.

Subpart A - General
1194.1 Purpose.
[...] implement section 508 of the Rehabilitation Act of 1973 [...]

and, according to:
=====
http://www.section508.gov/index.cfm?FuseAction=content&ID=12#Software
Subpart B - Technical Standards
1194.21 Software applications and operating systems
[ ... ]
(k) Software shall not use flashing or blinking text, objects, or other elements
having a flash or blink frequency greater than 2 Hz and lower than 55 Hz
=====

__ OP __

 

[Bob I]

Once per second is 1 Hz, 60 Hz is 60 cycles per second, but both are
outside the defined range.

hi, Sir !

Bernard Liengme wrote in message ...
I do hope the OP saw Chips warning at the end of his notes:
Blinking text may not be allowed in applications for governmental bodies,
since it may be in violation of Section 508 of the Rehabilitation Act Of 1973
(since blinking text can cause seizures in epileptic patients).

may I ask if a blinking text, handled by OnTime procedure
once every second (60 Hz), could it be disrupting that regulation ?

TIA,
hector.

Subpart A - General
1194.1 Purpose.
[...] implement section 508 of the Rehabilitation Act of 1973 [...]

and, according to:
=====
http://www.section508.gov/index.cfm?FuseAction=content&ID=12#Software
Subpart B - Technical Standards
1194.21 Software applications and operating systems
[ ... ]
(k) Software shall not use flashing or blinking text, objects, or otherelements
having a flash or blink frequency greater than 2 Hz and lower than 55 Hz
=====

__ OP __

 

[Héctor Miguel]

hi, Bob !

Once per second is 1 Hz, 60 Hz is 60 cycles per second, but both are outside the defined range.

as far as I can see, defined (forbidden) range is 3 Hz to 54 Hz
so, I am presuming that 1 Hz is "acceptable" (is that wrong ?)

regards,
hector.

Héctor Miguel wrote:
hi, Sir !

Bernard Liengme wrote in message ...
I do hope the OP saw Chips warning at the end of his notes:
Blinking text may not be allowed in applications for governmental bodies,
since it may be in violation of Section 508 of the Rehabilitation Act Of 1973
(since blinking text can cause seizures in epileptic patients).

may I ask if a blinking text, handled by OnTime procedure
once every second (60 Hz), could it be disrupting that regulation ?

TIA,
hector.

Subpart A - General
1194.1 Purpose.
[...] implement section 508 of the Rehabilitation Act of 1973 [...]

and, according to:
=====
http://www.section508.gov/index.cfm?FuseAction=content&ID=12#Software
Subpart B - Technical Standards
1194.21 Software applications and operating systems
[ ... ]
(k) Software shall not use flashing or blinking text, objects, or other elements
having a flash or blink frequency greater than 2 Hz and lower than 55 Hz
=====

__ OP __

 

[Bob I]

Yes, that is the correct interpretation.

hi, Bob !

Once per second is 1 Hz, 60 Hz is 60 cycles per second, but both are outside the defined range.

as far as I can see, defined (forbidden) range is 3 Hz to 54 Hz
so, I am presuming that 1 Hz is "acceptable" (is that wrong ?)

regards,
hector.

Héctor Miguel wrote:
hi, Sir !

Bernard Liengme wrote in message ...
I do hope the OP saw Chips warning at the end of his notes:
Blinking text may not be allowed in applications for governmental bodies,
since it may be in violation of Section 508 of the Rehabilitation Act Of 1973
(since blinking text can cause seizures in epileptic patients).

may I ask if a blinking text, handled by OnTime procedure
once every second (60 Hz), could it be disrupting that regulation ?

TIA,
hector.

Subpart A - General
1194.1 Purpose.
[...] implement section 508 of the Rehabilitation Act of 1973 [...]

and, according to:
=====
http://www.section508.gov/index.cfm?FuseAction=content&ID=12#Software
Subpart B - Technical Standards
1194.21 Software applications and operating systems
[ ... ]
(k) Software shall not use flashing or blinking text, objects, or otherelements
having a flash or blink frequency greater than 2 Hz and lower than 55 Hz
=====

__ OP __

DT wrote in message ...
Is it possible to make the contents of a cell flash when the value reaches a certain level? ...

 

[Héctor Miguel]

hi, Bob !

Yes, that is the correct interpretation.

I really appreciate your time in reply to my doubt

regards
hector.

Héctor Miguel wrote:
hi, Bob !

Once per second is 1 Hz, 60 Hz is 60 cycles per second, but both are outside the defined range.

as far as I can see, defined (forbidden) range is 3 Hz to 54 Hz
so, I am presuming that 1 Hz is "acceptable" (is that wrong ?)

regards,
hector.

Héctor Miguel wrote:
hi, Sir !

Bernard Liengme wrote in message ...
I do hope the OP saw Chips warning at the end of his notes:
Blinking text may not be allowed in applications for governmental bodies,
since it may be in violation of Section 508 of the Rehabilitation Act Of 1973
(since blinking text can cause seizures in epileptic patients).

may I ask if a blinking text, handled by OnTime procedure
once every second (60 Hz), could it be disrupting that regulation ?

TIA,
hector.

Subpart A - General
1194.1 Purpose.
[...] implement section 508 of the Rehabilitation Act of 1973 [...]

and, according to:
=====
http://www.section508.gov/index.cfm?FuseAction=content&ID=12#Software
Subpart B - Technical Standards
1194.21 Software applications and operating systems
[ ... ]
(k) Software shall not use flashing or blinking text, objects, or other elements
having a flash or blink frequency greater than 2 Hz and lower than 55 Hz
=====

__ OP __

DT wrote in message ...
Is it possible to make the contents of a cell flash when the value reaches a certain level? ...

 

[Bob I]

You are most welcome, have a great day!

hi, Bob !

Yes, that is the correct interpretation.

I really appreciate your time in reply to my doubt

regards
hector.

Héctor Miguel wrote:
hi, Bob !

Once per second is 1 Hz, 60 Hz is 60 cycles per second, but both are outside the defined range.

as far as I can see, defined (forbidden) range is 3 Hz to 54 Hz
so, I am presuming that 1 Hz is "acceptable" (is that wrong ?)

regards,
hector.

Héctor Miguel wrote:
hi, Sir !


Bernard Liengme wrote in message ...
I do hope the OP saw Chips warning at the end of his notes:
Blinking text may not be allowed in applications for governmental bodies,
since it may be in violation of Section 508 of the Rehabilitation ActOf 1973
(since blinking text can cause seizures in epileptic patients).

may I ask if a blinking text, handled by OnTime procedure
once every second (60 Hz), could it be disrupting that regulation ?

TIA,
hector.

Subpart A - General
1194.1 Purpose.
[...] implement section 508 of the Rehabilitation Act of 1973 [...]

and, according to:
=====
http://www.section508.gov/index.cfm?FuseAction=content&ID=12#Software
Subpart B - Technical Standards
1194.21 Software applications and operating systems
[ ... ]
(k) Software shall not use flashing or blinking text, objects, or other elements
having a flash or blink frequency greater than 2 Hz and lower than 55 Hz
=====

__ OP __

DT wrote in message ...
Is it possible to make the contents of a cell flash when the value reaches a certain level? ...