Blinking Conditional Formatting... Yes Excel Is Blinking

[@coolag74]

Never thought that this will happen in Excel. Fantabulous and hats off to you. Excellent explanation and teaching. Felt that you are in front of me. Definitely, it will help me in my other dashboard for an alert. Learn a lot of things...

[@Officeinstructor]

What a nice and motivating comment... Thank you... Truly appreciated

[@rajchannalchainpura8902]

Excellent explanation and teaching of Blinking Cells and it will happen in Excel we never thought , Excellent Task ✌

[@SolomonKinyanjui_sk]

This is wonderful and I'm going to apply it in my data analysis. Excellent work. Keep it up Sir.

[@dddoda]

One thing I'd do about cell D1. Add a macro button over it, with a text, such as "Stop Blinking." The macro attached to the button would type the "1" for you. That way, all you need to do is use your mouse to click on the button instead of going to D1, typing in a "1" and then hitting enter. You could even add a macro if statement to it, saying if there is a 1 already there, to delete it. So you can go back and forth.

[@rickkeev4919]

Great video. I would recommend to your viewers to use a named range for your totals comparison cells so as transactions are added the code would still work.

[@Officeinstructor]

Thank you Rick for the recommendation

[@stacywilliams7931]

Beyond amazing...and guess what? I haven't watched the entire vid yet. Nabil's vids are always out of this world!

[@Officeinstructor]

I'm thrilled from your comment... Thank You Stacy

[@123mailashish]

Best wishes n good health. TC Mr. Nabil. U need to be preserved so that u keep making excellent videos.

[@Officeinstructor]

i will keep doing my best for my wonderful followers

[@sheshaankpydikondala9376]

I never thought about this.. excellent tutorial

[@Officeinstructor]

Glad you enjoyed it

[@Pankaj-Verma-]

One of the best video ever seen on Excel topic.

[@Officeinstructor]

I appreciate your nice comment... My followers deserve the best

[@stevennye5075]

Nice combination of techniques!

[@sasavienne]

You are amazing. Thanks indeed Nabil for all your valuable efforts.

[@Officeinstructor]

Thank you for the nice words

[@Scaw]

A very clear, nicely paced presentation. I look forward to more of them.

[@nadermounir8228]

Amazing trick. 👏 Thank you Nabil 😊

[@Officeinstructor]

Glad you liked it

[@amolmane8747]

Nice information and presentation as well....new commer will also understand with the help of your presentation... thanks for sharing!!!!!

[@pnagarajkumarbe]

Brilliant. Also the animation is pretty good. Can you tell me what is the tool you used for the animation.

[@Officeinstructor]

Thank you. For animation I only use PowerPoint. For recording I use Camtasia Studio

[@vincysigma]

Wonderful.. Tricks.. Thank you Sir.

[@alpeshpopat1702]

Excellent work sir, please launch more videos on macros

[@rupeshkhubchandani4342]

Tremendous work... Good morning.

[@christopherschembri7793]

Thank you for this extremely useful tip.

[@Officeinstructor]

Glad you found value in it

[@ashoksahu9546]

Excellent video sir.

[@Officeinstructor]

Thank you

[@prasathj7436]

Excellent Sir !!!

[@Officeinstructor]

You are most welcome

[@jutatiprodjanasiribut6951]

Great job!. It's fun. Will of course apply this to my work :)

[@jutatiprodjanasiribut6951]

When I tested, it got error at Worksheet Change said that it expects to call Variable or Procedure, not Module (BlinkCell). Any hint? thanks

[@abaurre3]

The solution works, but the UX, at least for me, is kinda lackluster. The cursor keeps cycling between the "busy" graphic and the regular cursor as long as the while loop is going. The DoEvents parameter makes it possible to edit values while it's running, but the cursor is kinda janky and laggy, making it feel like the spreadsheet is lagging or hanging.

[@alaysispatrick0920]

Nice video blinking. Please made video blinking sheet name wise. For daybook with on/off button. Cell A1,g7,E3,c4 blink.

[@dhunpagla3871]

Superb Mr Muraad ...Thanks 👌🙏

[@Officeinstructor]

I'm happy you liked it

[@ocean99a]

Dear Officeinstructor Thanks for this excellent explanation I tried to register on your site more than once but I was unable to enter the registration page And every time a blank page appears and there is nothing.Thanks again and please solve this problem

[@Officeinstructor]

Thank you for the nice comment. I added a different download link to the video description. You can use it until I fix the broken link

[@rajivjat]

Way of presentation and voice quality are excellent..

[@Officeinstructor]

Thank you... The Best Is Yet To Come

[@rajivjat]

@@Officeinstructor Does the recent announcement from Microsoft about VB is also applicable to VBA also ? Please guide about the future of VBA.

[@saravanansharan3394]

Really amazing... Done a fantastic code

[@Officeinstructor]

Thank you

[@She_Tried_It]

When I went over to view the Worksheet (Click Tab > View Code) 6:56 , I can't get back to the original code with the color changes. Crtl+R 8:50 didn't get me back to the module. Was I supposed to save it first? I don't have the heart to start over if I lost it...

[@shaamilstudios1585]

Great Work ! Very rare knowledge

[@georgetosounidis5545]

Great video! Liked how you explained the built of the VBA code. Could we use a key combination which would be recorded by excel to stop / re-enable the blinking (or any other macro), not typing 1 etc? like ctrl-break? Subscribed and bell clicked! Keep it up :)

[@zaighamuddinfarooqui1705]

What a great idea. Very well done Mr. Nabil. 👍👌👌

[@Officeinstructor]

Thank you my loyal friend

[@Mitr2u]

Cant copy the code, it requires memberships

[@Officeinstructor]

@@Mitr2u Membership is a click away... it's totally Free

[@douglasburnside]

I was so disappointed watching this video. Oh, it is a wonderfully done video, full of excellent information and I could even understand the logic of what you are doing. But I was hoping you were going to explain some hidden magic that would let me make a blinking cell using just the choices within the Excel conditional formatting function, without using VBA. I guess I'll just have to finally force myself to learn VBA. Thanks for the great video. Upvoted.

[@Officeinstructor]

Thank you Douglas for the comment... I agree that any solution without VBA will benefit more users since not everyone is using VBA. However, when you have hundreds of thousands of viewers, and many of them are advanced users, SOME of the tutorials are dedicated to VBA curious users. The exercise files have been downloaded over 35000 times from my website in one week of posting ... Isn't that an indicator? If I don't like SUCHI...it doesn't mean it should be banned. In life, it is IMPOSSIBLE to make everyone HAPPY although I wish... and, TRUST me I do my best

[@nairobi203]

Nice explanation.... Great

[@rajeshshah6758]

Awesome presentation and helpful too.💙

[@taiyosangyo7530]

This is very helpful sir, how to resume again blinking again of "H1" if you delete number 1 on "D1"?? thanks

[@nileshmetkar1737]

Great sir.. concept is good.. your video animations is attractive.. can you plz guide me how to add animation in video

[@Officeinstructor]

I use PowerPoint and Camtasia Studio

[@piroozpakdel9415]

Thank you

[@salahmed7273]

Many thanks, Sir,, from Sal from Amman - Jordan

[@rijomathew]

I do this in a lot fewer steps.. no coding... Conditional formatting, time function and a hidden collumn

[@Officeinstructor]

Great Rjo... It will be good to share your concept so everyone can benefit.... The goal of this channel is to share our knowledge

[@linabella9523]

​@@Officeinstructor if your goal is to share your knowledge why you dont share code.because im a new in vba and with the video i didnt succes. i dont know whats wrong.

[@SolomonKinyanjui_sk]

Hi? In case i have two or more independent cells how can I ensure they blink according to given condition independently?

[@jasonstatham7424]

Many thanks

[@Officeinstructor]

You are welcome

[@sarthakwebsoft]

Wonder full video. May i know which software are you using to create this video?

[@Officeinstructor]

Camtasia

[@mnsoyan]

Brilliant!

[@n4xlsolution613]

#nixelpresentation Voww.. How nice and simply you presented this tutorial. Enjoyed it. Thank you!

[@Officeinstructor]

Thank you

[@Pitter5775]

Hi Sir this codeing is verygood but when i applied .the cursor is constantly spinning..means getting slow.Plz suggest

[@Officeinstructor]

That's normal because a macro is running while you use Excel

[@queeniegonsalves417]

Nabil u r superbbb. But VBA doesn't works on my desktop ...entire excel goes for a toss 🥴🥴

[@Officeinstructor]

Then just watch the video... The Best Is Yet To Come

[@MAHESH_IRCON]

Excellent

[@Officeinstructor]

Thank you so much 😀

[@kiranchoudhari5225]

My cell remains orange coloured if i close my editor. Do i have to keep the editor running/minimized everytime i open the file to keep the code running?

[@Officeinstructor]

That's weird... Closing the VB editor should not affect the functionality

[@neelimakammila7891]

Thank you for the video!! Please could you explain If Not Application.Intersect(Target, Range("B5:E19")) Is Nothing Then

[@nponobeghuk]

When you modify a cell or a range somehow, the event will be called and Target is a reference to the modified range. Application.Intersect checks if there are some cells in common between two ranges. In this case Target (the one that you just modified) and B5:E19 (which is the range we'd like to monitor). Let's check scenario 1: you modify a cell inside B5:E19 range. In that case, Application.Intersect will return a range of cells that are in common between cells you just modified and B5:E19. Scenario 2: this time you modify a cell outside B5:E19 range. Application.Intersect will return Nothing, which is a kind of empty object. For the execution of our macro, we are interested in scenario 1, but actually the outcome of scenario 2 is a fixed value "Nothing", which is easier to track down. So instead of checking "did I click inside the range" (in which case the return of Application.Intersect would be unclear and we would have trouble setting the if conditional), we check for "did I NOT click OUTSIDE the range" (Application.Intersect returns Nothing if we click outside, and we use Not to discard all the clicks "outside" that return Nothing, and use all the other ones).

[@Officeinstructor]

That's a wonderful explanation... Thank you .

[@viswanathn3263]

Awesome logic

[@mindsetuk]

This is a great tutorial however .... The website,code and sheet can't be downloaded or don't work. And the code works but hangs - it's in some never ending loop I guess but I am not good enough to get it to stop. Very frustrating!

[@CBTvideos]

Would you know how to do this? Column A is a previous total Colum B is the new total If the value in the adjacent cell in Column B to Column A is lower, highlight red. I need it for the whole range i.e. B1:B52 however has to also be if A1>B1 Red, if A2>B2 Red, etc etc I tried manually doing the conditional formatting and when I use the sort option, the formatting doesn't keep the rules, it changes the formulas

[@ivanpap634]

Great!

[@souravgupta4416]

Can I get the VBA Code used

[@Officeinstructor]

Read the video description

[@yujaliria8486]

this is cool

[@IvanCortinas_ES]

Thank you for the video. One question please!: When I execute the code and change any number and start the blink, I see the pointer of mouse in "mode hibernation". Thats possible the state of the pointer of mouse normal? Thank you!!

[@Officeinstructor]

The reason is, you are using Excel as usual while a code is continuously running in the background... and that slows Excel. This kind of functionality is more "Showy" than "Practical"

[@atiqsarwar4222]

How can I apply this to long data set, like I want to use this in employee probation period expired or not...

[@Officeinstructor]

Definitely NOT recommended... this code is more Showy (To impress your boss) than practical as it slows Excel

[@jaysolanki8366]

Can We reduce the wait time further less than one second? Is that possible?

[@Officeinstructor]

No

[@jaysolanki8366]

@@Officeinstructor okay thanks for ur reply😊

[@Randy_G]

Thank you. Liked and Subbed.

[@niyiabdul6243]

Thank you for the video. But just one problem. In executing the code, my VBA editor keeps flagging "Set CellToBlink = Range ("H1")" as being incorrect. I'll appreciate any help on this, sir.

[@Officeinstructor]

Try again

[@JPAlpano]

How did this work without saving the file as xlsm?

[@sandeshvartak5156]

If my sheet is protected then what I need to add in vba script.

[@suhailnbd]

Awesome

[@Officeinstructor]

Thank you

[@Qtrainer]

So what do you do if Alt + F11 does nothing? Version 2002

[@Officeinstructor]

Time to upgrade my friend... we are in 2020 (just different order of digits from 2002)

[@OracleBizz]

Thank you sir

[@arinarin8702]

Can not download the code please

[@saleembukhsh7682]

How can apply this to a large number of cells?

[@Officeinstructor]

Not recommended... This functionality can only be used sparingly as it slows Excel performance

[@Vicky_view]

I want to flash multiple cell , how i can do this

[@Officeinstructor]

You need to modify the code but I do not recommend that as it slows the performance

[@linabella9523]

​ Officeinstructor if your goal is to share your knowledge why you dont share code.because im a new in vba and with the video i didnt succes. i dont know whats wrong.

[@Officeinstructor]

Not only I posted the Exercise File but also I wrote All the steps in details on my blog site + the Code for easy copy and paste... There are over 35000 downloads in less than a week. To make this available to viewers and followers I host all that on my blogsite. I used to put a direct link for download then I became a victim of hack and my website crashed... To avoid this situation while I keep sharing everything (Knowledge , Time, Effort...) for FREE I ask viewers to register as Bronze members (Totally Free) to protect my website and my intellectual property. All details are in the video description.

[@niyazfazeenaniyazfazeena1495]

Wow

[@Janardhanreddys]

So VBA this wont worked out right

[@rockiebhay5423]

hi i want making data entry for company

[@ahmadsharjeel1849]

how to copy

[@Saad.PS2009]

استاذ /نبيل مراد محتاج كود لإخفاء المعادلات في الاكسيل مع خالص الشكر والتقدير والاحترام

[@Officeinstructor]

إبعتلى ايميل و انا اقولك تعملها إزاى الايميل بتاعى على الويب سايت

[@Saad.PS2009]

[e-mail]

[@jerry171460]

I went to www.see-how.ca/blinking...but I couldn't sign up to become a member. The screen kept showing a blinking diamond in the middle and nothing else. In other words, I couldn't download the exercise file. Any help is appreciated.

[@johnjacobjinglehimerschmid3555]

meh.... I did this once and TBH it works but it's gimmicky. Now if you could get a GIF to work .... then make a flashing gif would be better IMO.

[@Officeinstructor]

That would be a lot of fun if you can make your GIF blink conditionally

[@johnjacobjinglehimerschmid3555]

@@Officeinstructor quite a few years ago at a former job. Had a guy, who had some software, make me a gif that would start red then go to transparent ... say 2 second cycles. Used it in a web page to indicate that a tool status had just changed on our factory communication board. Would have loved to make it work in a workbook tho.

[@ahmadsharjeel1849]

where is vba code

[@izharisr]

How to save that file and how does work next time open the worksheet

[@Officeinstructor]

dot XLSM format

[@maikyboy6341]

Sir, Can I download this example file ?

[@Officeinstructor]

Sure, You can download the file and copy the code if you want. The link is in the video description. You will need to register on my blogsite (Free)

[@Mitr2u]

Nope, Pay n Get

[@Mitr2u]

@@Officeinstructor if it is free, then why it is available for brownz memberships

[@vrmsali]

Plz indent the code. It is just a good practice.

[@Officeinstructor]

Sure ... Thank you for your NICE comment

[@Ahmed-fq6si]

I still can't understand why you put such a noisy music?

[@prerit86]

In what world is this conditional formatting?

[@goodgame9591]

I need out

[@sanjibpramanik9268]

Sorry, but this type of code is not a very good idea, coz it slowdown excel.

[@thesexiestguy]

Sanjib Pramanik, as of 07:52 17MAR2020, among 60+ people who commented on this video, you and I are the only 2 of such opinion... OP should tell his audience that such blocking calls should be best avoided... I was holding my breath hoping that he is not going to use ontime/callbacks... And this is clickbait, no where near conditional formatting but rather involved vba...

[@sanjibpramanik9268]

@@thesexiestguy Exactly, this is a clickbait. I think excel VBA coding is very easy to learn, but very few people actually know about how to write a safe code that harmless for our application and computer processor. 90% of them can't try to understand why they should use array instead of use range object or cell reference. Excel VBA event's are very useful, but using event to create a blinking cell that change fill color randomly with some conditions is nothing but just a funny thing to show kid's 😜😁 Thanks for your reply 😇

[@subratadatta3914]

I am failed to be a member www.see-how.ca/. Whats prob?

[@Officeinstructor]

No one had a problem before... try again

[@goodgame9591]

im problem pressing comment

[@sunilperera4837]

Pbbperera

[@IFSJAIPUR]

avoid vba codes , do as much as you can do without vba , if you have to write a vba code, file need to be saved to xlsm format , then opening macro files is not considered safe

[@vivek-qp1zs]

Total confusing 😉 sry not a student of computer

[@Officeinstructor]

On top of that you should be at least an intermediate user of Excel to learn VBA. I create Tutorials for users of different levels

[@markfalina9160]

SPEAK ENGLISH!!!!!!!!!!!!!!

[@rainier-rawai]

Good work, very clear, thanks. Is it possible to modify a little bit: Can keep the « stop » by 1 in cell D1... but would like to have an automatic stop after 20 seconds... Is it possible?

[@Officeinstructor]

Yes, you can. May be I create a tutorial on that in the future

[@dastagirshaikh9777]

How can I apply this blinking cell formatting to the cell without condition.

[@Officeinstructor]

Not recommended as it will slow Excel enormously