Рет қаралды 21,081
Download the featured file here: www.bluepecant...
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
------------------------