Next, we can now optically highlight the weekends. To do this, we mark all the days in our calendar, and then select the item “Use formula to determine the cells to be formatted” via the “Conditional formatting”, and enter the following function for the “Saturday” first: = weekday (B4; 2) = 6
Then we go to “Format” and look for a background or font color with which we want to highlight the day optically. Of course, you can use any form of formatting you can think of here. In our example we simply chose a green gradient.
After confirming with “OK” and “Apply”, all Saturdays are immediately displayed in the calendar with the selected formatting. In order to now also emphasize the Sundays, use the same function, only that this is then not 6 but 7 (Sunday as the 7th day of the week).
See fig. (Click to enlarge)