Color specific cells in bulk🎨

The shift table...

· Troublesome

・ Simple

・ But it takes time

There s a lot of repetition, right 😭

Especially

"I want to change the color only for holidays"

Isn't this a simple hassle?

If you apply it by hand

✔ paint

✔ wrong

✔ Redo each time you modify

Honestly, it's hard.

For those who are in charge of shifting

I will do [shift table series] for a week ✨

[It ends quickly because it is done every month]

Introducing time saving 🪄

😎 today

How the color changes the moment you enter "rest"

[Operation method]

① Select the range you want to color

② [Home] → [Conditional Format] → [New Rule]

Select "Format only cells that contain the specified value."

④

Cell value - > "Equal to next value"

Enter "rest" in the value field

⑤ Select the fill color in [Format]

⑥ OK

👉 this

The moment you type "rest,"

It is color-coded automatically!

Once you set it up.

Even if you enter or modify it later

All ✨

📌 and use it to create the next shift

👀 follow for more

In the next video

We will introduce the setting that automatically enters the date and day of the week!

- - - - -

On this account.

For those who are not good at computers and lack confidence

"I didn't know...!" changes to "I did it!"

We are sending PC basics and time saving techniques 💻🔰

I'm starting to feel sorry for asking around

· I want to graduate from my own style soon

・ I want to gain confidence in office work

Such a person

"I think I can do this too."

So that it seems...

Let's reduce the discomfort of computers together 🌸

I am posting this post.

・ Excel / Word time saving technique

・ Basic operations that make office work easier

· Beginners are easy to stumble point explanation

▼ Profile

· PC instructor experience 20 years

· Support more than 2,000 beginners so far

· Calicon qualified / It is an ally of those who want to change jobs 🍀

▼ There are many other time saving techniques

@ yuri _ pcwork