How to Make a Google Sheets Checkbox List with Strikethroughs & Colors

How to Make a Google Sheets Checkbox List with Strikethroughs & Colors

In this tutorial, I will show you how to create interactive checkbox lists in Google Sheets. These dynamic checkboxes will automatically cross out items from lists and change the text and background colors when selected. Google sheets is a free to use spreadsheet program located within Google Docs. If you are looking to make interactive task lists, these features within Google sheets will spruce up the look of your projects.

01:00 - Insert Checkbox in Google Sheets
02:24 - Format List with Strikethroughs and Color Change

✅ Social Media

📷 My Gear

DISCLAIMER: This video and description contain affiliate links. If you purchase through one of these links, I’ll receive a small commission at no additional cost to you. As an Amazon Associate, we earn from qualifying purchases.

#googlesheets #googledoc #howto

[MoonDarkchild]

Is is possibe to apply the formatting for the entire row and not just one cell?

[lienphan]

This is amazing! I’ve been searching for these formulas for more than a year! I can’t thank you enough. Thank you so so much. I very much appreciate what you’ve done.

[grovlingpoet]

This was a very helpful video. IT was able to help me after many failed internet searches.

[RyRobio]

Extremely helpful video indeed! Thank you for this!

[jahongiryakubov]

Thank you it works, I saw another video where it was "IF=H15=TRUE", but "IF" was unnecessary

[TheModernGlitch]

Thanks for helping me figure this out!!

[sarahdefoe]

This was so helpful! Thank you! I am hoping to make an assessment tracker for my classroom with this option!

[crystalmosley]

Thank you! SUPER helpfull! Now I just need to learn how to add more columns.

[romeroca]

Obrigado amigo! Procurei vários vídeos na internet e o seu foi o mais explicativo e sem enrolação. Parabéns.

[dollieSmith-tlvo]

So it only worked for one cell for me even thought i highlighted multiple cells to apply the rule to. could you help me with this please?

[tundeodebunmi]

Thank you for this tutorial. My question. Is it possible to lock the checkbox to prevent it from unchecked. Rgds

[Property.management]

How do you sort by strikethru? I want to move my completed items all to the bottom as they check off

[gregdavidd]

Great video thank you. In my case I want to have the text with a strikethrough with the checkbox unchecked, once checked the strikethrough would disappear but I cant seem to do this when I apply the conditional formatting. So what I did was apply text formating before starting your instructions and then followed through but could not remove it..

[dustonmeyer]

I have a checkbox in column E I know how to make check boxes and I know how to make it so if I check it I can turn column c red. What I dont know how to do is if I have a checkbox in E and also in F if just E is checked it is red if just F is checked it is blue but if both E and F are checked it turns Green. I have the checkbox values set to 5 so E=5 and F=5 but both E and F = 10 what is the formula to change the color of a column when 2 or more check boxes are checked

[LookPastThis]

Is there a way to do this on the actual tickbox?

[angelicaclark]

How do you add interactive comments to each line

[nursesth]

Can this be done for individual students?

[sarahsorochan]

How would I do this if I have multiple checkboxes? I have 3 rows of checkboxes and each one that I check I want it to turn a different colour so I know what stage I'm at