Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-05-2013, 06:53 PM
macropod's Avatar
macropod macropod is offline Cells That Blink Windows 7 32bit Cells That Blink Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,520
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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
Run the macro and the target cell will flash if your criterion is met. Of course, rather than having to run the macro manually, you could use something like a event to trigger the macro.
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]
Reply With Quote
Reply

Tags
excel cells that blink



Similar Threads
Thread Thread Starter Forum Replies Last Post
Cells That Blink 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
Cells That Blink Un even cells lostsoul62 Excel 5 10-17-2012 08:33 AM
Cells That Blink 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

Other Forums: Access Forums

All times are GMT -7. The time now is 12:41 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft