Automatically translated.View original post

ゆい｜仕事がラクになるExcel術

71 followers

Follow

Follow

Follow

64 saved

24

[Excel utilization] Manual NG! A moment with God's work! Saturday and Sunday coloring ✨

Other posts from here 💁‍♀️

@ yui _ exel _ work

Saturday and Sunday color painting, can be automated 🔖

─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─

◆ How to automatically color-code Saturdays and Sundays with conditional formatting ◆

① Select the range you want to color

② Open "Conditional Format" - > "New Rule"

Select "Use a formula to determine the cells to format."

④ Enter "= $C6 =" soil "" in the format setting field

⑤ Select your favorite background color from "Format" and click "OK"

⑥ Do ① to ③ for Sunday, enter "= $C6 =" day "" in ④ and go to ⑤

◇ point ◇

Change the "C6" part to match the cell containing the day of the week ☺️

─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─

Please "Like ❤️" and "Save 🔖" if you like 😊

Please feel free to comment and DM 🌸

Excel technique to make work a little easier 📊

Follow here → @ yui _ exel _ work

# excel # Excel # excel _ time # Excel Time Shortener # excel _ beginner

3 days agoEdited to

普段からExcelを使ってスケジュール管理や予定表作成をしていると、土日を手動で色分けするのは意外と時間がかかって面倒ですよね。そんな時に条件付き書式を活用すると、一度設定すれば日ごとに色を自動で変更できるので、作業効率が格段にアップします。私も最初は手動でひとつずつ色を付けていたのですが、毎週繰り返す作業に疲れてしまい、この方法を取り入れてからは大幅に作業時間を短縮できました。特に、曜日が記載されたセルの列を指定し、土曜日と日曜日それぞれに数式を設定することで確実に色が反映されるので、おすすめです。注意点としては、曜日情報が入ったセルの位置（例えば上記の「C6」など）が異なると、数式内のセル参照も変更する必要があるため、設定前にシートの構成をしっかり確認してください。また、背景色はお好きな色にカスタマイズ可能なので、カレンダーのデザインに合わせて調整するのが良いでしょう。さらに時短を追求する場合、色の設定を複数のシートや共有ファイルに適用する際は条件付き書式のルールをコピー＆ペーストすると便利です。Excelの色分けを活用して、デスクワークの効率化をぜひ試してみてください！

Related posts

A collage featuring four different supplement containers: apple cider vinegar gummies, green tea extract, protein powder, and L-carnitine. The image is overlaid with the prominent text "TOP SUPPLEMENTS FOR WEIGHT LOSS".

A bottle of green tea extract supplement. Overlay text describes its benefits for boosting metabolism and fat burning, recommended daily dosage, and its use for enhancing fat oxidation during workouts.

A container of protein powder. Overlay text explains its importance for muscle repair, satiety, and metabolism, suggesting its use in smoothies or oatmeal to curb hunger and maintain muscle.

Best Fitness Supplements for Weight Loss 💪

Looking to support your weight loss journey with the right supplements? Here’s a breakdown of top-rated, effective options that can complement your diet and exercise routine. Remember: no supplement is a magic pill—pair these with healthy habits for the best results! 🌱💪 1️⃣ Green Tea Extract 🍵

2957 likes

How to Do a Successful Manual Blood Pressure! 🩺✨

Taking a manual blood pressure reading can be stressful but with practice and good knowledge, you can excel with these tips and techniques! I used to feel the same way but the more I did it, the more comfortable it became. These tips that I just revealed has helped me immensely in my career

1585 likes

Excel time stamps

Yes, I said permanent time stamps #exceltips #excel #tutorial #worktips #exceltraining #exceltricks

53 likes

A person in blue shorts and a sports bra holds a dumbbell, with various food items like meat, eggs, peas, shrimp, yogurt, and tofu floating around them. The text overlay reads 'Foods For Glute Growth What to Eat for Muscle Growth & Recovery'.

A chart titled 'PROTEIN SOURCES CHART' displays various foods like chicken breast, eggs, cottage cheese, salmon, lentils, tofu, shrimp, and bison, along with their protein content per 100g.

An infographic titled 'Top 5 Foods for Recovery' features images and descriptions of chocolate milk, tart cherry juice, peanut butter and banana sandwich, yogurt and granola, and a fruit smoothie.

Foods & Drinks I eat to Grow BIG & Strong GLUTES🍑

Muscle-building foods I use to fuel my fitness goals, along with some meal ideas I often to incorporate into my diet: 🥚Eggs: ✅Breakfast: Veggie omelette with eggs, spinach, onion, chicken sausage, and tomatoes. ✅Lunch: Egg salad sandwich on whole grain bread. ✅Dinner: Quiche with eggs, cheese

3541 likes

Types of Digital Products You can Sell

🪩🫧🎧 Hey Darlings!🩶 Digital products are intangible assets that can be sold and distributed online, providing numerous opportunities for earning passive income. By exploring different digital product types, you can find those that align best with your skills and passions. Each product type offe

231 likes

How I Ruined My Credit at 19 😭 (and Fixed It)

When I was 19, I got my first credit card with a $525 limit… and I treated it like free money 😭. I was buying little “treats” here and there — coffee, skincare, random Target runs — thinking minimum payments were no big deal. Then the interest hit. Then the late fees. My balance felt impossible

604 likes

The Avocado Seed: Waste Not

The Avocado Seed: Waste Not, Want Everything For years, the ritual of enjoying an avocado ended abruptly at the core. We carefully sliced around it, twisted the halves, and then thwack—the large, smooth, mahogany-colored pit was aggressively excavated and tossed into the compost bin (or worse, th

31 likes

🔥 1987 Toyota pick up SR5 4x4🔥

186k Miles Shown Fuel-Injected 2.4-Liter Inline-Four Five-Speed Manual Transmission 1,605 Dual-Range Transfer Case Repainted Silver Metallic Grav Side Graphics 162 Gray Cloth Upholstery 15" Allov Wheels Bilstein Shock Absorbers 258 Front Disc Brakes Bed-Mounted Toolbox Kenwood eXc

4 likes

Maximizing space utilization 🤩 A small study successfully transformed #sofa #sofabed #home #homedesign #bed

1 like

The Magic of the Living Machine

Ever wondered how a slice of pizza transforms into the energy you need to sprint, or how your heart knows exactly where to send a breath of fresh air? Your body is a high tech biological masterpiece, operating through perfectly synchronized systems. It starts with Nutrition, where organs like the s

66 likes

Excel Power Trick: The Magic of Ctrl + Shift! 💡🔥

✨Welcome to Our Excel Mini-Class! 📈 In this session, we’re unlocking the magic of Ctrl + Shift combo to supercharge your Excel workflow! 🚀 Ever found yourself needing to quickly format time, date, currency and percentage? 🙋‍♀️ Ctrl + Shift is your secret weapon! With just a few simple keys, you

5 likes

Secure Your Excel Data Like a Pro: Set Password 🔒✨

💥 Welcome to Our Excel Mini-Class! 📈 Today's session is all about how to secure your excel data. Do you deal with sensitive data in Excel and want to keep it safe from prying eyes? 🔍 Whether you're a student, professional, or just love staying organized, learning how to set passwords o

7 likes

A MacBook Air screen shows a resume with red annotations highlighting common errors like wrong tense, typos, passive voice, and inconsistent punctuation. Overlaid text advises starting with a professional summary and using action verbs.

Resume secrets from a FAANG employee

✨ Facebook Apple Amazon Netflix and Google (FAANG) can be some of the hardest companies to break into! ✨ If you're applying to competitive roles, these tweaks actually make a difference 👇 1️⃣ Start with a professional summary Let recruiters know who you are and what you bring to the table

145 likes

A resume template for Jonathan Brooks, an early-career tech professional, with sections for summary, work experience, education, skills, and certificates. The text "Get Hired by Top Companies!" is overlaid in orange.

A resume template for Sarah Morgan, a customer service representative, detailing her professional summary, education, work experience, and skills. The text "Stand out Get Hired!" is overlaid in orange.

A resume template for Ethan Rodriguez, a finance and accounting executive, showcasing his professional summary, work experience, skills, and educational background. The text "Easy to edit!" is overlaid in orange.

Resume Templates - Hired by Top Companies ✅

With over 5 years of experience recruiting for global companies like BMS, Merck, Amazon, Johnson&Johnson, Stryker, Northrop - I’ve reviewed thousands of resumes and helped hundreds of professionals land interviews at Fortune 500 companies. I’ve learned what hiring managers like and what gets

151 likes

Must-Know Excel Tip for Busy Days! ⏰ 🥰

✨ Welcome to Our Excel Mini-Class! 📈 In this session, we’re unveiling the magic of Text to Columns! 🤓 Have you ever had a long list of data all in one cell and wished you could separate it into neat, organized columns? Well, now you can—with just a few clicks! 🔥 No more messy data or manual cutt

4 likes

Understanding Credit Utilization

Understanding credit utilization ratio is one the most powerful steps you can take toward healing and building your financial future. It is truly inspiring to watch yourself balance what you owe against your available limit, turning a simple percentage into a reflection of growth and dedication. By

1 like

Trade lines are one of the most overlooked credit strategies out there 👀 Adding the right trade line can significantly increase your credit score — sometimes by as much as 150 points — by strengthening your payment history, increasing your average credit age, and lowering your utilization. If you

136 likes

Don't follow the trend, don't hype, focus on the research and development and production of peptide raw materials With bioactive peptides as the core, it covers the fields of health and scientific research. ✔ High purity: 99%+, no additives, no hormones ✔ High activity: advanced fr

1 like

Becoming Her: Finance Edition

✨ Financial confidence is a form of self-care. You deserve to feel secure, stable, and in control, because becoming the woman you want to be includes financial wellness too. 📌 Save this post & share with your girls—financial freedom is a lifestyle! I’ve created a free budgeting worksheet

1812 likes

You know what’s really funny? We can remember celebrity drama, song lyrics, AND who unfollowed who… 😭 …but ask us what a credit utilization rate is and suddenly we need a nap. 🫠💳 A lot of us weren’t taught money, credit, or how to build real stability.That’s why I’m big on learning now instead

0 likes

Nursing hustles

#nursetips #sidehustle #nurselife #moneymaking #entrepreneur

234 likes

#verifiedonlemon8 #honestreview #elf Random Thoughts 💭What's on my mind: How to guides for Excel Current Mood: Accomplished ⭐Rate: ⭐️⭐️⭐️⭐️⭐️

0 likes

Replying to @1badgyal_p 1. Share this to someone who may need a step by step. 2. ASK IT ANYTHING YOU WANT TO KNOW REGARDING YOUR REPORT. 3. Pay it forward ✨✨✨ #credit #creditscore #creditscoreincrease #buildingwealth #investingforbeginners

1 like

Excel cheat sheet

Excel cheat sheet #excel #exceltips #exceltricks #exceltraining #tutorials #excel_learning

14 likes

You Don't Need a Dispute Strategy

You Need a Clarity Strategy. WHAT TIKTOK GOT WRONG 😶 You've been following the advice. Disputing everything. Waiting for 680. Sending the letters. Starting over. And nobody told you it might not be necessary. WHAT I SAW FROM THE DESK 📊 📋 A 620 isn't a dead end — it's F

2 likes

A tip to make you distinguish from ur colleagues!✨

👉 Welcome to Our Excel Mini-Class! 👋 Tired of text getting cut off or spilling out of cells in Excel? 😅 Today, we’re showing you the Shrink to Fit feature—a simple way to automatically adjust text size so it fits neatly inside any cell! 📝💼 Perfect for making your spreadsheets look clean, organiz

3 likes

#great book #good book #bookquotes

6 likes

8 likes

A purple square with a white border overlays a background of purple flowers. The text inside reads: "The Best Time-Saving Tools Every Business Owner Needs." Below, "SWIPE" with an arrow indicates to scroll, and "Lemon8 @organized2flow" is in the corner.

A purple rectangle with white text overlays purple flowers. The text describes "Automation Tools for Sales and Marketing," including setting up automated sales funnels, email marketing automation, and social media scheduling tools to save time for business owners.

A purple rectangle with white text overlays purple flowers. The text details "Streamlined Product Delivery," covering automated digital delivery systems, membership sites for access control, and instant payment processing to ensure efficient customer transactions.

The Best Time Saving Tools for Business Owners

As a business owner, particularly in the world of digital products, time is your most valuable resource. Every minute spent on tasks that don’t directly contribute to revenue is a minute wasted. If you're selling PLR (Private Label Rights) and MRR (Master Resell Rights) digital products, you&#3

2 likes

For a long time, I thought financial freedom meant making more money. But honestly? I needed better habits first. I started learning about credit, budgeting, utilization, and how small financial decisions affect your future. Little by little, I stopped trying to “look rich” and started

6 likes

Best Alkaline Herbs for Iron all of these are part of our Blood 🩸 (Iron) Supplement except for sea moss. We recommend pairing sea moss capsules with our iron supplement for best results, link in bio: • Sea Moss - Rich in iron; supports red blood cell production and circulation. • Quassia - Bo

3 likes

An image overlaying the title 'DEALING WITH DEBT COLLECTORS DO'S & DON'TS' on a financial dashboard. The dashboard displays monthly expenses, incomes, credit card usage, and transaction logs, illustrating financial management concepts relevant to debt.

An image titled 'DO's' listing six actions for dealing with debt collectors, including requesting validation, verifying debt, disputing incorrect information, negotiating, recording everything, and seeking help from the CFPB. The background is a financial planning template.

An image titled 'DON'TS' listing three actions to avoid when dealing with debt collectors: don't communicate before validation, don't do nothing, and don't forget to pay taxes on canceled debt. The background is a transaction log template.

👇KNOW your Rights - Dealing with Debt Collectors

#debtcollector prey on negative feelings and all they care about is meeting their quotas. They don’t care if the debt is legitimately yours so here are some things that you shouldn’t should not do when interacting with them. DO’S: 1. Request a validation letter - they have 5 business days f

522 likes

NYX Make ‘EM Wonder Soft Matte Foundation

The shade for this line is GOOD! 45 shades to choose from. I don’t think I ever hated a #nyxprofessionalmakeup foundation/skin tint launch. Are we shade twins??? #nyxcosmetics #nyxmakeup #blackgirlmakeup #shadetwins

8 likes

Make handmade bags with old clothes #handmadebags #lifetricks #wasteutilization #creativediy #sewingtutorial

6 likes

Credit utilization - be careful high spenders 💳✈️

0 likes

A close-up of stacks of US hundred and twenty dollar bills on a dark background, with the text '10 Things I wish I knew About money at 18!' overlaid.

A blurred background of money with a green text box listing financial tips: '1. Your income matters more than budgeting' and '2. Credit is a tool, not a trap'.

A blurred background of money with a green text box listing financial tips: '3. LIFESTYLE CREEP WILL KEEP YOU BROKE' and '4. STARTING EARLY BEATS STARTING PERFECT'.

10 Things I wish I knew about money at 18!✨🫶

I wish someone sat me down at 18 and explained money like this. Not in a boring lecture way — just the real-life stuff you only learn after messing up a few times. The truth is, most of us were thrown into adulthood with zero guidance. No one told us about credit. No one showed us how to buil

179 likes

#gardeningtips #gardeninghacks #gardentips #rawmilk #milkrecipe

0 likes

✨ Welcome to Our Excel Mini-Class! 🐶 In this session, we’re diving into essential Excel functions that will save you tons of time! ⌛ From quick calculations to powerful data organization, these functions do the work for you—no more repetitive tasks! 🔄🔍 These go-to functions will boost your produ

3 likes

Don’t forget to get your copy! We are moving on to the next step!

Everyone on my platform should have this FREE copy now. I will help you in the next chapter of your journey. Want to learn how to make money online so that you can either pay down debt or supplement the income you already have? You are in the right place, at the right time, IN the right company

9 likes

Your credit profile affects more than just a score.

It can impact: • approvals • interest rates • business opportunities • buying power • future goals A lot of people don’t realize what’s actually hurting their profile until it’s too late. I’m doing a few FREE Credit Profile Reviews this week for anyone who wants a better understanding of

0 likes

#creditutilization #creditrepair #creditscore #parttwo

20 likes

Sis, it’s time to stop playing small. 💳💼

It’s 2025, It’s time to live your best life!! We’re using credit as a tool—not a trap—to build wealth, fund our goals, and create freedom. 🔑✨ No more broke mindsets. No more bad credit holding us back. We’re fixing scores, stacking savings, and stepping into the soft life we deserve.💅🏾 #LevelUpL

6 likes

Replying to @Em trust me I’m just as surprised as all of you 😅😅 #buyingahouse #creditcarddebt #creditcards

2 likes

Some medications deplet nutrients for some..

0 likes

✨Time Management Hacks I Swear By in the Office✨

Deadlines, meetings, and a never-ending inbox… here’s how I actually stay on top of it all: 📅 1. Batch your meetings Cluster calls together so you protect big blocks of focus time. ⌨️ 2. Master keyboard shortcuts Ctrl + C / Ctrl + V is just the beginning—shortcuts cut hours of wasted clicks

6 likes

See more