Susan Harkins shows you how to combine a function and conditional formatting to highlight weekends and holidays using Excel. Weekends and holidays are important to most of us. Besides enjoying the ...

Last year, I showed you a dynamic approach to using conditional formatting to highlight weekends in a monthly matrix-style calendar. In that article, "Use Excel's conditional formatting to highlight ...

Last month, we used conditional formatting to highlight holidays in a matrix-style calendar; we added this enhancement to an earlier article that used conditional formatting to highlight weekends. By ...