How to make the data in a cell blink?
 

I have a formula in the cell that does a calculation. I
need the data to be red in colour and to blink only when
the result is negative. Can anyone show me how to do it
in excel?

Thanks.

How to make the data in a cell blink?
 

to make it blink, you would need to change the color at a periodic rate.
You can use the application.Ontime method to do this.

See Chip Pearson's page on this
http://www.cpearson.com/excel/ontime.htm

How to trigger it would depend on how it becomes negative. If through a
calculation, use the calculate event. You will need to store its state, so
you don't trigger the blinking on every calculate as long as the cell stays
negative - unless that is what you want.

--
Regards,
Tom Ogilvy

ds328 wrote in message
...
I have a formula in the cell that does a calculation. I
need the data to be red in colour and to blink only when
the result is negative. Can anyone show me how to do it
in excel?

Thanks.