View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Rick Rothstein Rick Rothstein is offline
external usenet poster
 
Posts: 5,934
Default Blinking cell if value is...

My suggestion is to not use blinking text... it is very annoying to look at.
However, if you must, look here...

http://www.cpearson.com/Excel/BlinkingText.aspx

--
Rick (MVP - Excel)


"Chip Pearson" wrote in message
...
If you really want blinking text (which I find highly annoying) you
need to use a VBA function. Excel itself doesn't support blinking
text. See http://www.cpearson.com/Excel/BlinkingText.aspx for code
examples.

Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

On Wed, 17 Dec 2008 08:20:07 -0800, Melissa
wrote:

So this is probably something that should be very simple, but it's giving
me
a headache.
I use excel at my job to keep track of stuff that needs to be picked up.
The
value of this cell is manually inputted whenever it changes, Excel doesn't
calculate the value in any way. If there's 2, I input two. If it's 0, I
put
in 0.
What I want it to do is blink if the value I input is greater than 0.
All the codes I've found only work if the cell value is being calculated
by
Excel, or it effects more than just this particular cell.

The cell used is J1.
I want the color of the background to remain the same grey color, and if
it's 0 the text is a light grey, if it's 1 or greater the text blinks
between
grey and bright red.

Can anyone help me?