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 😁

@ひろ|Excel-時短テク