Automatically Highlight Weekends in a Mini Calendar (Google Sheets)
In this video, I’ll show you exactly how to use conditional formatting in Google Sheets to automatically highlight weekends inside a mini calendar layout.
Highlighting weekends is perfect for:
• Monthly mini calendars in planners
• Content calendars and posting schedules
• Budget calendars and bill trackers
• Event planners and appointment layouts
You’ll learn how to:
✔ Use the WEEKDAY formula to identify Saturdays and Sundays
✔ Create a custom conditional formatting rule
✔ Apply formatting to a full mini calendar grid
This is a beginner-friendly tutorial with practical examples you can easily apply to planners, trackers, and business spreadsheets.
Perfect for spreadsheet beginners, planners, teachers, and digital creators who want functional spreadsheets that still feel cute and organized ✨
🙋♀️ New to Google Sheets? Check out the FREE mini course, Wildheart Spreadsheet Academy: https://thecreativewildheart.com/academy
✨ Join the FREE Wildheart Spreadsheet Society Skool community: https://thecreativewildheart.com/skool
// FORMULAS + RESOURCES MENTIONED //
☑️ Bill Calendar Workshop: https://checkout.thecreativewildheart...
Formula: =WEEKDAY(B5,2) greater than 5
*YouTube doesn't allow to me use the greater than or less than symbols in my video description so please replace the words with the correct symbols.
• B5 is the first date cell in your mini calendar
• Note: The 2 allows it to treat Monday as 1 so that Saturday and Sunday would be numbers as 6 and 7.
// CHECK OUT //
👉 Free mini course: https://thecreativewildheart.com/academy
👉 Free Google Sheets workshops: https://www.thecreativewildheart.com/...
👉 Join the free Skool group: https://thecreativewildheart.com/skool
👉 Google Sheets Membership (cool tutorials, live monthly challenges, and a supportive community): https://www.thecreativewildheart.com/...
👉 Shop the Google Sheet Templates: https://store.thecreativewildheart.com/
#GoogleSheets #GoogleSheetsTutorial #Spreadsheets #Spreadsheet #SpreadsheetDesign #GoogleSheetsForBeginners #CuteSpreadsheets #DigitalPlanner #SpreadsheetTemplates #GoogleSheetsTips #CreativeSpreadsheets #GoogleSheetsDesign #DigitalProductCreator #GoogleSheetsIdeas #GoogleSheetsForBusiness #GoogleSheetsTutorials #GoogleSheetsBasics #SpreadsheetBasics #AestheticSpreadsheets #GoogleSheetsAesthetic