How to make the data in a cell blink?

[ds328]

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.

 

[Tom Ogilvy]

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.