Susan Harkins shows you how to combine a function and conditional formatting to highlight weekends and holidays using Excel.

Build on this earlier calendar that highlights weekends to also highlight holidays. This technique relies on the NETWORKDAYS () function, which is available in Excel 2007 and later versions.