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 |
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 |
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 |
How can I make a cell to flash?
|
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 |
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 |
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. |
All times are GMT +1. The time now is 02:00 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com