Calendar that can be automatically colored on Saturdays and Sundays
@ひろ|Excel-時短テク← Click here for other computer time saving techniques
How was this post? 💡
If you think "This is convenient!," please save it so that you can look back later 📌
- - - - - - - - - - - - -
I didn't know 🔥
I knew 👍
I set it up → ✨
- - - - - - - - - - - - -
[Automatic color coding in an instant! How to make a Saturday and Sunday calendar 💻]
On the Saturday and Sunday lines of the monthly calendar,
Are you coloring one by one by hand?
That's just plain daily petit stress, isn't it 😭
People who work quickly can quickly set the back of conditional formatting,
Even if the moon changes, it is an ideal state that is automatically color-coded in an instant ✨
Here is a procedure that becomes much easier once set 👇
① Range selection
First, select the entire data!
② Function selection
From "Conditional Format"
↓
Select "New Rule"
③ Rule selection
Click on the bottom (use a formula to determine which cell to format)
④ Saturday's formula
Enter "= WEEKDAY ($mark before B in date cell, 2) = 6" in the formula input field
⑤ Color setting
Select your favorite color (such as blue) from the format
↓
This will automatically color on Saturday!
⑥ Sunday setting
Same procedure on Sunday, set the color (such as red) with "= 7" at the end of the formula
↓
With this, both Saturdays and Sundays will be automatically colored!
- - - - - - - - - - - -
Let's graduate from monthly manual coloring today!
In this account, Excel and personal computer work is "without hesitation, stop" I am sending a time-saving trick to be easier 💻
People who want to reduce overtime work today, please take a look at other posts 😁
