Forum Discussion
Using VBA to make a cell blink
Just to show you how annoying it is, I have attached an example.
If you search for Excel VBA cell blink I'm sure you can find some code to do it. It is that hard but I highly discourage it. Excel has built in Conditional Formatting that would be much more efficient and will be compatible going forward. VBA is not supported in web Excel or some other platforms and is disabled by default so anyone opening such a sheet has to open it in desktop version and allow the macros to run.
In conditional formatting you can highlight column G and then choose a custom formula and simply type
=F1+45<G1
and then choose bright red or something very obvious.
I know this isn't blinking but unless you give me a compelling reason why a bright red cell isn't obvious enough and you must have blinking I just don't want to encourage that usage. Remember if someone opens the sheet and does NOT allow macros then they will not see that blinking but with conditional formatting supported across platforms they will see the bright red cells.
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: