Thread: flashing cell
View Single Post
  #2   Report Post  
JulieD
 
Posts: n/a
Default

Hi Rob,

would formatting it lime green & purple help? seriously, you'll need to use
VBA to achieve this, so i'm not sure it falls into the simple category,
however, Rob van Gelder posted this answer to a similar question a couple of
months back
*****
Check out my website for "Schedule a macro to run"
Include something like:
Sub RunMe()
With Range("A1").Font
If .ColorIndex = 3 Then .ColorIndex = 4 Else .ColorIndex = 3
End With
ScheduleNextEvent
End Sub
or if you want the background to blink: With Range("A1").Interior
--
Rob van Gelder - http://www.vangelder.co.nz/excel
******

Hope this helps
JulieD

"Rob at BTAS Inc." wrote in message
...
Is there a simple way to make a cell blink or flash or otherwise be very
distinctive from other cells?