Let’s have a list of dates or some kind of calendar. We want to highlight first Mondays or Tuesdays or Wednesdays etc. in each month. The example shows how to use conditional formatting to solve this task. Continue reading “How to highlight first Monday of the month in Excel table” »

In this example, I will use conditional formatting to color weekends in the calendar. Let’s have following calendar for checking attendance.

Continue reading “How to highlight a specific day in the calendar” »