Thank you for the tutorial! I came here for the conditional formatting but the "COUNTIF" part will be super handy as well. Out of curiosity, is there any way to make it where I can click any spot in the cell that has the check box and it will check it off? Rather than having to click directly in the check box square?
Hi there. Great video. I am using two check boxes per row so when I check one and later the other, I have to go uncheck the first one. I there a way to check one automatically unchecking the other?
Hello, I found your video very informative. So thanks for making it. But have a question How can i make it if one check box is is True the rest switch to False ? Been Trying for days and cant get it to work. If M4 Checked I want M5-M9 unchecked. If M5 Is checked I want m4 and m6-m9 unchecked and so on. I then need to read the cells so if one is checked it pulls data form other fields to change values. IF you could point me in the right direction, that would be great. Thanks
Nice video. Do you have a formula that would automatically minus from a total every time a box is checked with out changing the value of the box.63-checkbox =62... thanks
Just the right level of detail and explanation ! Clear and concise, and foolproof too. Thank you !
Great tutorial! Concise and easy to follow
THIS IS THE BEST TUTORIAL I HAVE EVER SEEN 👍
Thank you for your excellent and clear explanation. I searched for clear video advice such as yours for about a week. Thank you 🙂
What I was looking for. Excellent tutorial! Thank you!
This is exactly what I needed. Thanks man!
Best video 🎥 lolout there I watched videos for days this helped get me get things done. 👊
Thanks a lot this is exactly what I looked for!
Great example Chester! I wish Microsoft would copy this feature from Google for EXCEL. Thanks for sharing :)) Thumbs up!!
Really handy and it's helped me a lot with my work and personal spreadsheets!
Sensacional! Era isso que eu precisava e você explicou muito bem! Obrigado!
Thank you for the tutorial! I came here for the conditional formatting but the "COUNTIF" part will be super handy as well. Out of curiosity, is there any way to make it where I can click any spot in the cell that has the check box and it will check it off? Rather than having to click directly in the check box square?
Thank you. I am looking to count check marked with the dates. Like how many ticks were marked a particular date. How to do that
Works perfect ✅
Hi there. Great video. I am using two check boxes per row so when I check one and later the other, I have to go uncheck the first one. I there a way to check one automatically unchecking the other?
How can I implement this in columns instead of rows? What do I need to change?
Hello, I found your video very informative. So thanks for making it.
But have a question How can i make it if one check box is is True the rest switch to False ?
Been Trying for days and cant get it to work.
If M4 Checked I want M5-M9 unchecked.
If M5 Is checked I want m4 and m6-m9 unchecked and so on.
I then need to read the cells so if one is checked it pulls data form other fields to change values.
IF you could point me in the right direction, that would be great. Thanks
Nice video. Do you have a formula that would automatically minus from a total every time a box is checked with out changing the value of the box.63-checkbox =62... thanks
ohh osm sir it's very helpful for me
Thank you!
Awesome! right to the points
this was really helpful, thanks!
is there any way to get a checkbox to change the color of a whole block of cells, not just the ones horizontal to it?
Thanks!
Great! Thankyou very much.
I have office 2021 and i cant find the tick box ! Can u help ?
Thanks, its help me a lot. 😊😊
Thanks
Much appreciated
Life saver!