View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_7_] Bob Phillips[_7_] is offline
external usenet poster
 
Posts: 1,120
Default Flashing Cells (Like stock quotes)

Carl,

I can't see you getting that with conditional formatting. As far as I am
aware, flashing has to be obtained with VBA, and so you couldn't use a
worksheet function, not even a UDF, which is what CF relies on.

--
HTH

Bob Phillips

"Carlton Patterson" wrote in message
...
Bob,

I couldn't really find what I was looking for on the Google link you
submitted. May be I just wasn't explaining myself properly. So, what I
would like is the following.

I would like to apply conditional formatting but the effect
to appear when my condition to be fulfilled should be
either or all of the below mentioned
1) Flashing cell for say 5 secs to highlight that cell
has changed, pretty much like a live stock quote
screen

2) Continuos blinking of the cell

3) Playing a sound when the condition is fulfilled

I hope someone can help me achieve this.

Cheers

Carlton

*** Sent via Developersdex http://www.developersdex.com ***