![]() |
|
|
|
#1
|
||||
|
||||
|
No, though it does have conditional formatting that could make the cell change colour. You could use an time-driven macro, but the effects are pretty awful...
As an example: To make a cell flash every second if it's value is 1, use conditional formatting in the target cell, with the formula: =AND(MOD(VALUE(TEXT(NOW(),"ss")),2)=0,A1=1) and set the conditional format to whatever font/background/border arrangement you want. Then add the following macro to the workbook: Code:
Sub FlashCell()
Range("A1").Calculate
Application.OnTime Now + TimeValue("0:00:01"), "FlashCell"
End sub
Note: change "A1" in the above references to any cell that does not contain a formula - unless you actually want the nominated cell to recalculate every second. Once the above has been done, all you need to do to make other cells flash is to copy the conditional format to those cells, changing nothing more than the "A1=1" argument to whatever 'flash' criterion you want. For example, if you want more than one cell to flash if "A1=1" , change "A1=1" to "$A$1=1" and apply/copy the format to those cells also. You could even get fancy, having up to three (or more in Excel 2007 & later) sequential flashes of the cell, by adding conditional format arguments and making the conditional format formulae, in turn: =AND(MOD(VALUE(TEXT(NOW(),"ss")),4)=1,A1=1) =AND(MOD(VALUE(TEXT(NOW(),"ss")),4)=2,A1=1) =AND(MOD(VALUE(TEXT(NOW(),"ss")),4)=3,A1=1) Be warned, though, routines like this can chew up CPU resources (i.e. they slow things down). As I said, the effects are pretty awful. For one thing, you'll lose any ability to copy/paste or undo while the macro is running - and the undo buffer will be cleared so you won't even be able to undo anything afterwards.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
| Tags |
| excel cells that blink |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Sum up cells
|
beginner | Excel | 2 | 12-03-2013 03:07 PM |
| In Excel 2007-After Selecting Visibe Cells-How do I "Copy to Visible cells" Only | mag | Excel | 0 | 10-28-2012 08:04 PM |
Un even cells
|
lostsoul62 | Excel | 5 | 10-17-2012 08:33 AM |
How-TO format cells (FILL) by comparing cells
|
zanat0s | Excel | 1 | 07-03-2012 04:27 AM |
| Count range cells eliminating merge cells | danbenedek | Excel | 0 | 06-15-2010 12:40 AM |