Highlight the Days of the Week With This Tutorial

In this Excel Tip and Trick I’m showing you how to highlight the weekends by giving the cells another background colour.


Select the Cells A2:A10
Go to Conditional Formatting
And select New Rule


Now select “Use a formula to determine which cells to format”
And type in =WEEKDAY($A2)=1
Now select Format
Go to the Fill tab and select a colour.
And click OK and at the OK at the New Formatting Rule Window.


You have now marked the Sundays because this function returns the days as an integer ranging from 1 (Sunday) to 7 (Saturday) by default.


If you want to mark the Saturdays with an other colour you change the 1 into a 7 which is now the formula =WEEKDAY($A2)=7.