Yeah, so I found this weird quirk in Google Sheets. In fact, I say weird quirk because ChatGPT said it is a weird quirk, and Che said it was not possible. So what I wanna do in Big Year, so Big Year is a calendar that is the entire year in one tab. And what's cool is that the Saturdays and Sundays are highlighted or colored in a different color.

It's not just one thing. It is also a school. I've created a school calendar for the next two years, or this year and next year. I've also created a tall version that goes up and down. I've created a checkbox version. I've created a tiny version that just has a tiny boxes with just the first three letters of every day in it. And then I even created a mini version.

Color it. If it's a seven color it, that's all it's doing. Essentially saying, get the weekday of this date. Color it one if it, if it's one or 7, 1 7 being Saturday and Sunday or seven and one being Saturday and Sunday.

So I set up this settings page and I said, Hey, just set your weekend seven in one here. And so if you go to edit the conditional formatting and you're like, I don't want one here, I want settings, exclamation point C3.

So how do we do it? Well, we're going to use the indirect now. I'm gonna do it over on the tiny version just in case anyone doesn't want it over there.

highlighting Thursdays and Saturdays. Or we can highlight one and two if that is your weekend. Sunday and Monday. There we go. Sunday and Monday.

I'm excited to be making a ton more videos here. Ask me questions down in the comments and I will answer them in future videos.