Highlight Weekends Dates and Bank Holidays in Excel - Formula & Conditional Formatting

Download the featured file here: www.bluepecantraining.com/wp-...
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
------------------------

[@Dwavard]

4m 27s - Fab explanation of how to highlight specific dates :-)

[@anthonykarungu1419]

Thanks for sharing the video. It is more than valuable to my analysis

[@soumiamoujane3695]

Thanks for sharing the video. I love your videos and they are helpful and useful.

[@ramstreamph]

I knew that is possible, I just don't know how to do it. Thank you so much for sharing!

[@RajeshKumar-ow2fs]

Excellent, very easy explanation

[@mohanpal2737]

Awesome vedio

[@GpD79]

This is very helpful, thank you! I'm trying to do this with xlookup, but I can't seem to figure it out ,as it doesn't seem to provide true and false like your vlookup does, Just curious how it would work using the xlookup! (I'm generally a big fan of xlookup!)

[@breakingbad582]

Hi thanks you so much share us this video. I wanna arrange weekend holiday date especially construction works make biweekly weekend( not every sunday, biweekly sunday- in within 14 days just one day ) is this possible arrange formula weekend holiday?