Highlight weekends and holidays with conditional formatting | Excel Tips #23

Excel SuperHero book: www.amazon.com/dp/B0B49CRTV6
In this video you will see how you can Highlight weekends and holidays (days off) with conditional formatting. We need proper formula for conditional formatting
=NETWORKDAYS($A2,$A2,$G$2:$G$3)=0
00:00 | Intro
00:04 | Checking for days off with NETWORKDAYS function
01:58 | Logical test for conditional formatting
03:58 | Conditional formatting
05:12 | Summary
#excel #conditionalformatting #networkdays
Files to download in the Eng folder on the website:
exceliadam.pl/youtube

[@user-ts1fr6sh5m]

Your videos have boosted my Excel confidence. I've aced my recent project, all thanks to your guidance!

[@ExcelAndAdam]

Thanks for your comment 😀

[@joannagrabowska3031]

Great solution😀

[@ExcelAndAdam]

I'm glad Joanna that you like the solution

[@ExcelAndAdam]

Want to get 3 chapters of the Excel SuperHero book? Sing up: ExcelAndAdam.com/book You can also find me on: 📚Blog - excelandadam.com/ 🍀Instagram - instagram.com/excelandadam/ 🌟Tik Tok - www.tiktok.com/@excelandadam ✨Facebook - facebook.com/ExcelAndAdam 🕊Twitter - twitter.com/ExcelandAdam