Automatically Highlight Weekends in Excel! (Conditional Formatting, Weekday Function)

This video explains how to highlight weekends in Microsoft Excel automatically . Conditional formatting automatically highlights weekends. The tutor covers how the weekday function works and how you can change the numbering options. The tutor goes on to cover how you can add conditional formatting, using the formula option, to one cell and have it fill down multiple cells. The final part of the video covers how to extend the conditional formatting to cover the whole row. Topics covered, Conditional Formatting, Weekday function and formula option in Conditional formatting. Automatically Highlight Weekends in Excel! (Conditional Formatting, Weekday Function) Most popular video at the moment: Spill Error, https://www.youtube.com/watch?v=uyNXVbpfsiE #msexcel If you want to support me, check this out: https://www.patreon.com/itseasy Playlists for this channel: Access: https://www.youtube.com/watch?v=WyFj2eeMfSI&list=PLK99llucAWls71sYcwuXUGuTB33Iz4sFP&ab_channel=ITsEasyTraining1st Excel: https://www.youtube.com/watch?v=yKobsDbGbyM&list=PLK99llucAWlt5BjHVQwlzFWcqtOR0xMsc&ab_channel=ITsEasyTraining1st Word: https://www.youtube.com/watch?v=1yB2yP_5LQ0&list=PLK99llucAWlvAvYnQHbuqPzahwXC2GP5T&ab_channel=ITsEasyTraining1st Visio: https://www.youtube.com/watch?v=ucHD0C4xeBY&list=PLK99llucAWlubxRVLca37R6Jh4jSZyxC3&ab_channel=ITsEasyTraining1st Project: https://www.youtube.com/watch?v=5Fmgei_PagI&list=PLK99llucAWltWM3-Ohg_V1d6Q0STPAzG7&ab_channel=ITsEasyTraining1st PowerPoint: https://www.youtube.com/watch?v=fOhiNLAzVAQ&list=PLK99llucAWluWCI4_xLnfbjm5GpAZo9Ye&ab_channel=ITsEasyTraining1st Publisher: https://www.youtube.com/watch?v=I1-DPJTSvg4&list=PLK99llucAWlvCyOwrQh-OSlPpXWBIEVYq&ab_channel=ITsEasyTraining1st OneNote: https://www.youtube.com/watch?v=JS5Y_BSEbgg&list=PLK99llucAWlteO7uOpQHz5rOBCdnZ0YMD&ab_channel=ITsEasyTraining1st Office 365: https://www.youtube.com/watch?v=fphQ0jmv0-8&list=PLK99llucAWlv0L0K0wsLW_S5VkOHFuxli&ab_channel=ITsEasyTraining1st #itseasytraining Classroom based courses can be arranged at https://www.itseasy.co.uk/ Courses are available through Microsoft Teams, Online and Face to face in the UK Online courses at https://itseasytraining.teachable.com/ Udemy Courses https://www.udemy.com/user/stephen-saxton/ Training Guide Books Excel for New Managers https://www.amazon.co.uk/Excel-New-Managers-understanding-Microsoft/dp/1695396863 Microsoft Project Overview https://www.amazon.co.uk/Microsoft-Project-Overview-need-about/dp/1705474632 Microsoft Visio Basic https://www.amazon.co.uk/Microsoft-Visio-Basics-Stephen-Saxton/dp/B089CSJBMD Very cheap E_books are here: Excel For New Managers https://payhip.com/b/IE4x Microsoft Project Overview https://payhip.com/b/wY0m Microsoft Visio Basics https://payhip.com/b/5XeV Microsoft Access Introduction https://payhip.com/b/ynSL A PowerPoint Overview https://payhip.com/b/YkQv