How can I make a cell to flash?

[amirstal]

Can anyone help with this:

How can I make a cell to flash a text, let's say "Warning!" whenever a
condition is met. For example, if cell A1 = cell A2, make cell A3
flash the text "Warning!".

Thanks,

Amir

 

[Bob Umlas]

In order for that to happen you'd have to have a macro running all the time
which is not a good idea. There is no Flash feature as there is in Word.

 

[Jon Peltier]

Do you want to annoy people, or merely alert them to a condition being met?
Use conditional formatting to highlight the cell.

- Jon

 

[Gary''s Student]

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

 

[amirstal]

Do you want to annoy people, or merely alert them to a condition being met?
Use conditional formatting to highlight the cell.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -http://PeltierTech.com
_______

Yes, I want something bolder than just conditional formatting. Indeed,
it is to provide a better alert.

Amir

 

[Bob Umlas]

Maybe you'll like this. In another cell, say Z1, put
=IF(A1=A2,"WARNING!!","") and hide column Z.
Insert a Textbox near A3, select the border. While the textbox is selected,
click in the formula bar and enter =Z1. Format its font as 28-pt, Red, Bold,
format the textbox itself as no fill, no border.
Now when A1=A2 you'll see the big bold warning and when they're different
you'll see nothing.

HTH
Bob Umlas
Excel MVP

Do you want to annoy people, or merely alert them to a condition being
met?
Use conditional formatting to highlight the cell.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -http://PeltierTech.com
_______

Yes, I want something bolder than just conditional formatting. Indeed,
it is to provide a better alert.

Amir

 

[amirstal]

Maybe you'll like this. In another cell, say Z1, put
=IF(A1=A2,"WARNING!!","") and hide column Z.
Insert a Textbox near A3, select the border. While the textbox is selected,
click in the formula bar and enter =Z1. Format its font as 28-pt, Red, Bold,
format the textbox itself as no fill, no border.
Now when A1=A2 you'll see the big bold warning and when they're different
you'll see nothing.

HTH
Bob Umlas
Excel MVP






Yes, I want something bolder than just conditional formatting. Indeed,
it is to provide a better alert.

Amir

Thanks.