I have a Google Sheets-driven daily tracker which I use to track every hour of my day for a whole year. This is the fourth year I've been doing this, so I've become mildly obsessed with getting this system to work exactly to my liking.
For quite some time, I've looked at other scripts for Sheets that others have made and the experience was largely disappointing and frustrating. I figured this would be an interesting little project to put out, and I'm publishing it in case someone has the same or similar needs as I did, and hopefully this will help with that.
Here is a screenshot of the exact spreadsheet structure and conditional formatting setup that this script was built for. I've included instructions in the script's comments detailing how to set up the conditional formatting.
Enjoy!