03-05-2018 08:05 PM
03-09-2018 03:27 PM
my personal opinion why in the conditional formatting in excel does not include the blinking mode is quite simple... (the programmers) THEY JUST SIMPLY MISSED IT!.... it totally slipped out of their minds!! IT ONLY SHOWS THAT THEY ARE HUMAN AFTER ALL........ why go through the tedious process of making a program for it when it can be readily built into the conditional formatting SIMPLY!?! admission does not mean guilty...:)
03-09-2018 06:36 PM
03-10-2018 04:43 AM - edited 03-10-2018 04:43 AM
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...
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.
03-11-2018 03:20 PM
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
03-11-2018 04:26 PM
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
Mr. Jamil Mohammad
can I trouble you again (maybe for the last time)
could you re-write the macro for just G27 to blink whenever B27 is blank (no need to reverse)
i.e. G27 will blink if B27 is blank - that's all
How can I send you the File for you to understand better.
I can not see "attach file" option
Thank you for your patience and assistance
Attached is the excel program I created for costing purposes.
your blink macro looked ok but I can not imbed it into the program as I have very little knowledge of VBA. your kind assistance would be appreciated very much
I don't know if this has sent the file "EUREKA Desking Program (per configuration).xlsm
if not pls tell me how to send it to you - so that you will better understand what I want for the blink.
Many many thanks
Mr Jamil Mohammad
Thank you for your reply.
STILL, I do not know how to attach the excel file "EUREKA Desking Program (per configuration).xlsm"
I can not see a provision for "attaching file" or a CLIP icon
I clicked the [Choose Files] - but I don't think it worked...
In the excel file I mentioned, in the opening sheet "FORMULA" - it has already a VBA macro -- I do not know how to insert your Blink macro -- the module for Blinking - I know - just insert a module and paste it....the rest still a puzzle....
or if it is not bothersome for you - can I have your email address so that I can send it directly to you....Thanks again