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

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.

"amirstal" <(E-Mail Removed)> wrote in message
news:3018dd3f-196b-49a4-a485-(E-Mail Removed)...
> 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

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
_______


"amirstal" <(E-Mail Removed)> wrote in message
news:3018dd3f-196b-49a4-a485-(E-Mail Removed)...
> 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

http://www.cpearson.com/excel/BlinkingText.aspx
--
Gary''s Student - gsnu2007k

On Sep 15, 2:45*pm, "Jon Peltier" <jonxlmv...@SPAMpeltiertech.com>
wrote:
> 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
> _______
>
> "amirstal" <amirs...@gmail.com> wrote in message
>
> news:3018dd3f-196b-49a4-a485-(E-Mail Removed)...
>
> > 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

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

Amir

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

"amirstal" <(E-Mail Removed)> wrote in message
news:c81c31f6-89cf-4882-8654-(E-Mail Removed)...
On Sep 15, 2:45 pm, "Jon Peltier" <jonxlmv...@SPAMpeltiertech.com>
wrote:
> 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
> _______
>
> "amirstal" <amirs...@gmail.com> wrote in message
>
> news:3018dd3f-196b-49a4-a485-(E-Mail Removed)...
>
> > 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

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

Amir

On Sep 15, 3:23*pm, "Bob Umlas" <bobum...@yahoo.com> wrote:
> 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
>
> "amirstal" <amirs...@gmail.com> wrote in message
>
> news:c81c31f6-89cf-4882-8654-(E-Mail Removed)...
> On Sep 15, 2:45 pm, "Jon Peltier" <jonxlmv...@SPAMpeltiertech.com>
> wrote:
>
>
>
> > 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
> > _______
>
> > "amirstal" <amirs...@gmail.com> wrote in message
>
> >news:3018dd3f-196b-49a4-a485-(E-Mail Removed)...
>
> > > 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
>
> Yes, I want something bolder than just conditional formatting. Indeed,
> it is to provide a better alert.
>
> Amir

Thanks.