If you have found this content useful and want to show your appreciation, please use this link to buy me a beer .
https://www.paypal.com/donate/?hosted_button_id=CGKRY2BAYEQBQ
Thank you!
Download the featured file here: https://www.bluepecantraining.com/wp-content/uploads/2021/01/Highlight-Weekends-Dates-and-Holidays-in-Excel.xlsx

In this video I demonstrate how to highlight (conditionally format) dates that are weekend dates or bank holidays. I show you how to apply the format to individual cells but also to the whole row.

The functions used are: WEEKDAY and VLOOKUP and ISNUMBER.

This video will answer the following queries:
Excel check if date is holiday
Excel formula to identify weekend dates
How to grey out weekends in Excel?
How to highlight weekend dates in Excel?
Highlight weekends and holidays in Excel
————————

Please take the opportunity to connect and share this video with your friends and family if you find it useful.