Forum Discussion
Excel blinking cell
wouldn't it be nice - if in the CONDITIONAL FORMATTING (IN EXCEL) there is a provision to blink a cell content whenever required (based on cell condition) rather than to make a program for it?? HOW HARD COULD IT BE??
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.
34 Replies
- thank you Jamil Mohammad, my idea is have the blinking BUILT into the conditional formatting so that macros will no longer be needed...
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.
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
the blinking cell is possible but not without use of Macros.
- Dear brother Jamil
I am trying to do the blinking cell for three conditions, If "On Duty" then "GREEN", If "On Leave" then "RED", If "On Waiting List" then "YELLOW" color. How to do it. I did my best and am getting error! Plz advise.. Many thanks sir I agree about the blinking cell built into Conditional formatting. MS is so close to doing this, under the Fill button there is an effects button as well where you can have one or two colors. It would be nice if MS included in this area a Blink/Flashing button/command allowing users to choose colors, time of flashing, number of times something blinked.
These are my thoughts on this subject.
Jamil wrote:the blinking cell is possible but not without use of Macros.
hi,hope you are doing great.
i tried below stated macros. but i am still stuck.
is there anyway i can put a conditional blinking for a column if the cell value says "no" then it should blink indefinitely and jsut for your info the column works on a formula. like if the validity has expired it will say "NO" in that particular cell.
Hi Shaker,
please see attached.
if you put in any cell in column A word no or result of formula. it will start flashing.
