You can make a checklist in Google Sheets and set up color coding. When a box is checked, it changes color.
Google Sheets tutorial: checklists.
Checklists are a list of checkboxes - tickboxes - in Google Sheets, and they're REALLY EASY.
No coding. No macros or VBA.
You can use checklists to:
track habits
store a simple task list
check off projects
Checkboxes in Google Sheets must be created on desktop, but the checkboxes can be updated (ticked) on the Google Sheets mobile app.
#googlesheetstips #googlesheets
Here's Google's Help Center page about how to Add & use checkboxes in Google Sheets
https://support.google.com/docs/answe...
00:00 Make checklist in Google Sheets
01:17 Color the checked boxes
01:40 Conditional formatting in Google Sheets
02:30 To do list with checkboxes
04:00 Count checkboxes in Sheets
===============================================================================
Check my Amazon Storefront:
https://www.amazon.com/shop/anthonyen...
DISCLOSURE: I often review or link to services, apps, and products which I've tried and recommend. Wherever possible I use referral links, which means if you click one of the links in this video or description and make a purchase I may receive a small commission or other compensation.
As an Amazon Associate I earn from qualifying purchases.
Many of my links to products/gear are links to those products on Amazon. I am a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for us to earn fees by linking to Amazon.com and related sites.
==============================================================================