How to Highlight Weekends in Google Sheets
Learn how to easily highlight weekends in Google Sheets using the WEEKDAY function and conditional formatting. This quick tutorial will help you visually distinguish Saturdays and Sundays in your spreadsheets.
You want to highlight your weekends. Maybe you have some sales ledgers, maybe you have different actions or interactions that are taking place among your company and your sales, wherever. You have a sheet, you have dates, and you wanna know which ones are weekends, and you just wanna highlight the weekends, anything that's on Saturday or Sunday. Here you go So we wanna highlight weekends, and this is really fun because in a particular cell, we can always put equals and have this date here and wrap it with weekday. Weekday is gonna actually produce a number And the very unintuitive, weird thing about Google Sheets is that the weekends are seven and one. What Can You Automate in Google Sheets? Every single trigger available to Google Sheet users Google Sheets Interface Changes Weekday Name in Google Sheets
So we use this weekday to get the number , and then we just have to say, "Is it one or seven?" And we can do this in conditional formatting . So let's highlight this date. Let's go to Format , Conditional formatting . Over here on the right, we're going to change our format cells rule to custom formula is equals weekday, and then we're gonna put the cell in there, A1, and that's going to automatically change as it goes down. And we're gonna say equals one. But if we want both one or seven, we can wrap this in or We're gonna highlight this and paste it and change the one to Use COUNTUNIQUEIFS Multiple Conditions to Count Weekdays of Sales Figure Out Frequency of Numbers How To Highlight Any Date One Week In Future
a seven, end parentheses and now it's highlighting either seven or one from this weekday formula . And that's it. That's how to highlight weekends You're watching Better Sheets here on YouTube. Watch this video or this video. It's gonna make your Google Sheets better Go ahead, ask me anything down below in the comments . And I'm going to answer it in a future video become a member of Better Sheets today. . You get videos, you get sheets. So what do I have to do to get you into a brand new Google Sheet? Go buy some tools that I've built inside of Google Sheets doing things in Google Sheets you never thought possible. Go check it out Better Sheets Videos Checklist 7 Best Beginner Tutorials Featuring the INDEX() Google Sheet Formula Better Sheets Videos Checklist Big Year