How to make the data in a cell blink?

  • Thread starter Thread starter ds328
  • Start date Start date
D

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.
 
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.
 
Back
Top