ALL BUSINESS ENGLISH ARTICLES MICROSOFT EXCEL TIPS

Create a vertical calendar – Excel

Excel Task

  • Create a vertical calendar for 2024 till 2028.
  • Show all the dates for the year selected from a drop-down list.
  • Set the background color for weekdays Saturday and Sunday to blue.
  • Set the background color for non-working days to red.
  • Create a button to clear all filters.

Views: 2

Comments are closed.

Pin It