Highlight Weekends in Google Sheets
Learn how to highlight weekends in Google Sheets using the WEEKDAY function and conditional formatting. This quick tutorial will guide you through the steps to easily identify Saturdays and Sundays in your spreadsheet.
we wanna highlight weekends, and this is really fun because 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. So we use this weekday to get the number , and then we just have to say, "Is it one or seven?" 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 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 a seven, end parentheses Big Year Update Edit Your Weekend Highlights Google Sheets Interface Changes How to Highlight Weekends in Google Sheets
now it's highlighting either seven or one from this weekday formula . And that's it. That's how to highlight weekends Big Year Update Edit Your Weekend Highlights How to Highlight Weekends in Google Sheets