Forum Discussion
Solved
Using VBA to make a cell blink
I am trying to figure out how to use VBA to make a cell blink in Excel. In the attached example, if a cell in column G is over 45 days old from the date in column F, I would like the corresponding ce...
Just to show you how annoying it is, I have attached an example.
I have conditional formatting set to change the cell to red when "No" is selected. I want it to blink when it has been "No" for over 45 days.
So use Hot Purple/Pink instead? Or change the Red to Orange and over 45 to Red. But I still think blinking / VBA is not the best solution. Remember you can do MORE than just fill using conditional formatting so you could also change font bold and underline, you can add patterns to the fill and you can add borders: