【エクセル 日付】カレンダーの土日・祝日に自動で色を付ける方法！エクセルカレンダーの日付を自動表示！土日・祝日の色も自動設定できます！

Excel Calendar Coloring Saturdays, Sundays, and Holidays

Just enter the year and month in Excel and we'll show you how to create a calendar that automatically changes the date!
You can also automatically color Saturdays and Sundays. You can also set colors for holidays and dates you want to color.
This will allow you to create a calendar that you can use for the rest of your life once you've made it.

[Table of Contents]
00:00 Digest: About this course
01:53 Automatic display of dates
08:24 Finding the day of the week
13:01 Coloring the day of the week
19:57 Coloring holidays

[Related Videos]
[Excel Row Insertion] A must-see for those who lose their formatting when inserting rows in Excel!
   • 【エクセル 行の挿入】エクセルで行の挿入をした時に書式が崩れてしまう方必見！エクセル...  

[Excel Movement] A must-see for those who want to easily move cells in Excel! This is the most efficient way to move cells in Excel! Swapping cells is also perfect with this!
   • 【エクセル 移動】エクセルでセルを楽に移動したいかた必見！エクセルでセルを移動する時...  

[Excel table creation] A must-see for beginners! An easy-to-understand explanation of Excel basics and table creation for beginners!
   • 【エクセル 表作成】初心者の方必見！エクセルの基本から表作成までを初心者にもわかりや...  

[Beginner] The basics of how to enter formulas in Excel! The first step in Excel calculations!
   • 【初心者】エクセルの計算式の入れ方の基本！エクセルの計算の第一歩！  

#Excel
#excel
#Calendar

★About Sial Computer School
We will help you shorten your work hours.
We also have lessons where you can pinpoint exactly what you don't understand at work.
For those who are far away, we also offer online lessons, so please feel free to contact us and ask for advice.
sialpcschool.yokohama/

Excel calendar Coloring on weekends and holidays