software

need to make a cell flash when it gets to a certain level on a spread sheet

Please don't. It's hard to do and even harder to look at!
Just use Format|Conditional Formatting to make the cell red
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

quot;BROOKOquot; gt; wrote in message
...
gt; need to make a cell flash when it gets to a certain level on a spread
gt; sheet
If you must do this abomination, see
www.cpearson.com/excel/BlinkingText.htm

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

quot;BROOKOquot; gt; wrote in message
...
gt; need to make a cell flash when it gets to a certain level on a spread
sheet
www.cpearson.com/excel/BlinkingText.htm

--
Kind regards,

Niek Otten

quot;BROOKOquot; gt; wrote in message ...
| need to make a cell flash when it gets to a certain level on a spread sheet
Bob, it would only be an abomination if I used it in the quot;prepared by Lambsquot;
cell, thereby taking all the credit for your and all the MVPs' assistance.

Brooko, thanks for asking the question. Now, where else can I put my name up
in lights..?

Regards,

lt;flashgt;
Lambs
lt;flashgt;

quot;Bob Phillipsquot; wrote:

gt; If you must do this abomination, see
gt; www.cpearson.com/excel/BlinkingText.htm
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove xxx from email address if mailing direct)
gt;
gt; quot;BROOKOquot; gt; wrote in message
gt; ...
gt; gt; need to make a cell flash when it gets to a certain level on a spread
gt; sheet
gt;
gt;
gt;

Disagree mate, flashing text is an annoying distraction at best, it may even
be illegal in some countries.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

quot;Lambsquot; gt; wrote in message
...
gt; Bob, it would only be an abomination if I used it in the quot;prepared by
Lambsquot;
gt; cell, thereby taking all the credit for your and all the MVPs' assistance.
gt;
gt; Brooko, thanks for asking the question. Now, where else can I put my name
up
gt; in lights..?
gt;
gt; Regards,
gt;
gt; lt;flashgt;
gt; Lambs
gt; lt;flashgt;
gt;
gt; quot;Bob Phillipsquot; wrote:
gt;
gt; gt; If you must do this abomination, see
gt; gt; www.cpearson.com/excel/BlinkingText.htm
gt; gt;
gt; gt; --
gt; gt; HTH
gt; gt;
gt; gt; Bob Phillips
gt; gt;
gt; gt; (remove xxx from email address if mailing direct)
gt; gt;
gt; gt; quot;BROOKOquot; gt; wrote in message
gt; gt; ...
gt; gt; gt; need to make a cell flash when it gets to a certain level on a spread
gt; gt; sheet
gt; gt;
gt; gt;
gt; gt;
It can cause epileptic seizures in some people.

quot;Lambsquot; wrote:

gt; Bob, it would only be an abomination if I used it in the quot;prepared by Lambsquot;
gt; cell, thereby taking all the credit for your and all the MVPs' assistance.
gt;
gt; Brooko, thanks for asking the question. Now, where else can I put my name up
gt; in lights..?
gt;
gt; Regards,
gt;
gt; lt;flashgt;
gt; Lambs
gt; lt;flashgt;
gt;
gt; quot;Bob Phillipsquot; wrote:
gt;
gt; gt; If you must do this abomination, see
gt; gt; www.cpearson.com/excel/BlinkingText.htm
gt; gt;
gt; gt; --
gt; gt; HTH
gt; gt;
gt; gt; Bob Phillips
gt; gt;
gt; gt; (remove xxx from email address if mailing direct)
gt; gt;
gt; gt; quot;BROOKOquot; gt; wrote in message
gt; gt; ...
gt; gt; gt; need to make a cell flash when it gets to a certain level on a spread
gt; gt; sheet
gt; gt;
gt; gt;
gt; gt;

Your clock is off Bernard.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

quot;Bernard Liengmequot; gt; wrote in message
...
gt; Please don't. It's hard to do and even harder to look at!
gt; Just use Format|Conditional Formatting to make the cell red
gt; best wishes
gt; --
gt; Bernard V Liengme
gt; www.stfx.ca/people/bliengme
gt; remove caps from email
gt;
gt; quot;BROOKOquot; gt; wrote in message
gt; ...
gt; gt; need to make a cell flash when it gets to a certain level on a spread
gt; gt; sheet
gt;
gt;

The only wat I know to make a cell flash is a macro that changes the
text colour or the background colour or text style.

If you want a macro for this then you will need to list the paramaters
eg what cell/s
what to change
how ong
what triggers the flashing
what stops the flashing--
mudraker
------------------------------------------------------------------------
mudraker's Profile: www.excelforum.com/member.php...foamp;userid=2473
View this thread: www.excelforum.com/showthread...hreadid=538041