Forum Discussion
Excel blinking cell
- Mar 13, 2018
Hello Lorenzo,
Thanks for the feedback. as per your PM. I have updated the macro. so that when G27 is empty, the B27 will start flashing. it will stop flashing when you put a value in G27. Please download the attached workbook which has the macro.
Lorenzo,
Thanks for your comments.
You are not the first person to ask for this functionality. Statistics show that most users do not want the option of blinking cells as the effects are pretty awful , and that simply changing the background color of cell is just as effective without the eye strain of a blinking cell.
MSFT prioritizes adding built-in functionalities based their assessment on best idea top suggestions. that's why they have created excel.uservoice.com Excel’s Suggestion Box for users to submit Ideas and suggestions for improving Excel.
Among many features requested in uservoice, the flashing/blinking cell only has the min votes ( two votes) as of today and you can add yours if you wish https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/33099685-flashing-cells-under-specific-conditions
It shows that only few users wants this feature, however the door for VBA based solution is open, simply few line of code time-driven macro can add the functionality for those users who really wants it. There could be thousands of functions and features that currently are being handled by User Defined Functions with VBA that are not available with built-in functions, imagine if everyone asks for their desired functions or feature to be added to Excel, what will become of Excel?
I have attached a sample file which is from fellow MVP Tom Urtis that shows how few line of VBA can deliver the flashing cell.

- Lorenzo KimMar 11, 2018Bronze Contributor
Mr. Jamil Mohammad
Thank you for taking time in my query - if it is not too much to ask, may I request for a little more help re:VBA
imagine I would like to blink cell A1 if the value of B1="" (or blank space) inside the worksheet named "DATAENTRY" - how would the program be written (macros?)
again, Thank you for your time
- JamilMar 11, 2018Bronze Contributor
Hi Lorenzo,
Please see attached workbook with Macro. try to put some value in A2 and unless you put a value in B2 it will keep flashing.
- Lorenzo KimMar 11, 2018Bronze Contributor
Mr Jamil Mohammad
I couldn't believe I receive your reply in such a speed!!
if I may bother you again - can you rewrite the macros just for A2 and B2 - no need for the whole rows -
Thanking you for your FANTASTIC reply