How to Use Excel Checkboxes with Strike Through

#CheckBox #Strikethrough #Excel #GeniusWorld
We can use the check box by using the amazing trick of conditional formating which includes the strike through using the different fonts and colors. We have also used the condition for the task completion.
************** Kindly Like and Subscribe for Support **********************
/ genius-world-ms-excel-...
Excel Tutorial :
/ @geniusworldteam
Don't forget to subscribe to our channel for more great Excel tutorials!
Visit us at: / genius-world. .

[@mauniep6456]

I tried it and it worked!!! THANK YOU!!

[@geniusworldteam]

Your Welcome !!!!

[@kadzo6614]

@@geniusworldteam same. i am really excited to learn something new

[@wrlomprez3802]

Exactly what I needed awsome tut

[@geniusworldteam]

Thank you !!!

[@nachoGuitar]

thanks bro

[@brokemomdiaries]

This is exactly what I needed right now, thank you so much for the help

[@geniusworldteam]

Your Welcome!!!!

[@tundeodebunmi6333]

Love this so much thank you. Please is there a way to protect the check box from being unchecked by unauthorised persons?

[@geniusworldteam]

Thank you so much for your kind words. We are working on this topic. Hopefully we will upload vedio soon on this topic.

[@arhamhabib9267]

🎉well deserved appreciate

[@geniusworldteam]

Thank you so much !!!!

[@Bobburger82]

Thank you very much.😊

[@geniusworldteam]

Your welcome !!!

[@kadzo6614]

*This was extremely useful*

[@geniusworldteam]

Your welcome

[@sairamganapathy557]

If I have more than 100 check box whether I need to link each every one one by one?

[@geniusworldteam]

Thank You for your comment. You can use Google Excel sheet or Ms Excel 365 to create more than 100 check boxes. It will save time to link it. Otherwise you will need to link each cell separately.

[@MrAhmed550]

thank you that was helpful

[@geniusworldteam]

Your welcome Mr.Ahmed

[@InHisWord91]

Excellent tutorial. Thank you! I just subscribed. :)

[@geniusworldteam]

Thank you so much for your support

[@SandileMbuli-we1pc]

Completed

[@Kerolos_Shaheedl]

Thanks bro

[@geniusworldteam]

Your welcome brother !!!

[@lensalvado11681]

Hi do you have tutorial if 3 choices are needed? for example, pending, incomplete, complete?

[@geniusworldteam]

Apologize but we can make multiple scenarios like Pending, Work in process, complete and Cancelled bu using the same technique that has been used for normal scenarios. We will try to make video on multiple scenarios in near future. Thank you for your feedback!!!

[@kamranahmed2295]

Great

[@geniusworldteam]

Thank You!!!

[@qaibnyiajhli6675]

Thanks

[@geniusworldteam]

Your welcome

[@ahafeezs]

6:11 Hide checkbox output text.

[@BarryJHoffman]

Great video! my check boxes are so small (Mac excel) can they be made bigger? thanks!

[@geniusworldteam]

The size of the check boxes are fixed in excel !!

[@generationsarising]

I am looking for a way to format some dependent tasks if the trigger is checked done. Is there a way to do that in excel?

[@Bobburger82]

It works in my laptop. But if I want to use in my tablet or phone. It seems the checkbox disappeared.

[@geniusworldteam]

Thank you for your feedback. You can check by installing different versions of Ms Office in order to support your file features.

[@ossiespencer4982]

Thank you for the video.

[@user-px4zd5zl7z]

Is it also possible when you check a checkbox that it dissapear to another sheet?

[@geniusworldteam]

You can link the sheet with formula. Hopefully it will work

[@user-im8rp5ib6l]

I have a problem because I have A LOT of cells to check. Is there not a faster way to copy and paste the format control to another cell? Or must I change EVERY SINGLE CELL of the entire document? T_T (sorry for my bad English, I hope my issue is clear)

[@geniusworldteam]

Thank you for you comment. I hope you are doing well. We have made simple video on it for many cells. Hopefully it will work. kzbin.info/www/bejne/nmqlZqaBo7dlrposi=IzpOhg7Pzjjlamn2

[@docasakamika]

No need to type "B3=TRUE". You can type only B3!!!! Also, no need to type "=$D3= ..." in Conditional Formatting. You can type only B3!!!!

[@geniusworldteam]

Thank you

[@sunitasingh9824]

Thank you

[@geniusworldteam]

Your welcome

[@MichelleRoxas-mg4mc]

what is the version of your excel? i'cant find the developer and also the check box. ty

[@geniusworldteam]

We have used Ms Excel 2007 for this example to make it easier and convenient for everyone.

[@gemsec]

Hi there, can this be done in Word please? Thank you

[@geniusworldteam]

Hello, It is quite difficult in word because we have to use Conditional Formatting option in excel.

[@sinnorith3401]

how to send you a pictures i want to show you a sheet

[@bruisedbanana1700]

How to do this when there are many rows, for example over 100+ rows?

[@geniusworldteam]

We can drop down cells and use formula to save time but we need to link each checkbox separately for big data

[@bruisedbanana1700]

@@geniusworldteam Exactly so we'll still need to link each cell individually for all the 100+ cells😫

[@geniusworldteam]

We are working on it and hopefully provide another way to save time

[@bruisedbanana1700]

@@geniusworldteam Ok thank you. I have data with over 100 rows that i would like to add checkmarks to but I can't. It will be nice if there was a short way to do it.

[@user-ub3mo2qy7b]

how to link the cell in one time?

[@geniusworldteam]

We have mde the recent video to create linked cells within one step. Hopefully it will benefit

[@ProfAdamSelene]

Sorry, das geht heute wirklich besser und einfacher!

[@geniusworldteam]

Yes, we can make it more easier and simpler or even complex as per requirement!!!

[@GilbertvdBroek]

the code in 4:51 does not work

[@kadzo6614]

everything worked for me