Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I make a cell to flash?
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I make a cell to flash?
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" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I make a cell to flash?
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" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I make a cell to flash?
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I make a cell to flash?
On Sep 15, 2:45*pm, "Jon Peltier"
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" wrote in message ... 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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I make a cell to flash?
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" wrote in message ... On Sep 15, 2:45 pm, "Jon Peltier" 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" wrote in message ... 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 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I make a cell to flash?
On Sep 15, 3:23*pm, "Bob Umlas" 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" wrote in message ... On Sep 15, 2:45 pm, "Jon Peltier" 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" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Make a cell flash | New Users to Excel | |||
make cell flash | Excel Discussion (Misc queries) | |||
How do I make the cell flash on and off ? | Excel Worksheet Functions | |||
how do i make a cell flash in excel | Excel Discussion (Misc queries) | |||
how do I make a cell flash | Excel Discussion (Misc queries) |