Master Conditional Formatting in Excel (The CORRECT Way)

Kenji Explains β€’ February 18, 2024
Video Thumbnail

About

No channel description available.

Video Description

Conditional formatting tutorial in Excel from beginner to pro. πŸš€Get FREE Excel chart templates from Hubspot: https://clickhubspot.com/mn9 πŸ†“ DOWNLOAD Free Excel file for this video: https://careerprinciples.myflodesk.com/hwq09uiouj LEARN: πŸ”₯Power BI for Business Analytics: https://www.careerprinciples.com/courses/power-bi-for-business-analytics πŸ“ˆ The Complete Finance & Valuation Course: https://www.careerprinciples.com/courses/finance-valuation-course πŸ‘‰ Excel for Business & Finance Course: https://www.careerprinciples.com/courses/excel-for-business-finance πŸš€ All our courses: https://www.careerprinciples.com/all-courses In this video you'll learn how to use conditional formatting in Excel from scratch. Conditional formatting is one of the most powerful features in Excel, yet 90% of Excel users don't know how to use it to its full capacity. So in this video we'll cover all of the key aspects so you can learn how to use it correctly. This includes conditional formatting formulas, data bars, color scales, and much more. After this conditional formatting tutorial in Excel, you will be able to apply conditional formatting to any work setting. SOCIALS: πŸ“Έ Instagram - https://www.instagram.com/careerprinciples/?hl=en 🀳 TikTok - https://www.tiktok.com/@career_principles πŸ§‘β€πŸ’» LinkedIn - https://www.linkedin.com/company/careerprinciples/ β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬ Chapters: 0:00​ -​ Conditional Formatting Basics 1:06​ - Custom Rules and Formats 3:46​ - Highlight Entire Row Using Formula 5:23​ - Highlight the Top Values 6:27​ - Conditional Formatting for Dates 7:18​ - Percentage Icons 8:42​ - Color Scales & Data Bars 9:34 - Bonus Feature

Transform Your Garden Today

AI-recommended products based on this video

Loading...
Outsunny 3-Tier Wood Raised Garden Bed, Elevated Planting Box, Outdoor Vegetable Flower Container, Herb Garden Indoor Kit, Gray

Outsunny 3-Tier Wood Raised Garden Bed, Elevated Planting Box, Outdoor Vegetable Flower Container, Herb Garden Indoor Kit, Gray

(39)
$89.91
FREE delivery Jun 12 - 13 Arrives before Father's Day
Loading...
Bonsai Starter Kit – 1x Bonsai Tree | Complete Indoor Starter Kit for Growing Plants with Bonsai Seeds, Tools & Planters – Gardening Gifts for Women & Men
Best Seller

Bonsai Starter Kit – 1x Bonsai Tree | Complete Indoor Starter Kit for Growing Plants with Bonsai Seeds, Tools & Planters – Gardening Gifts for Women & Men

(243)
$19.99
FREE delivery Sat, Jun 14 on your first order
300+ bought in past month
Loading...
Environet Hydroponic Growing Kit, Self-Watering Mason Jar Herb Garden Starter Kit Indoor, Windowsill Herb Garden, Grow Your Own Herbs from Organic Seeds (Basil)

Environet Hydroponic Growing Kit, Self-Watering Mason Jar Herb Garden Starter Kit Indoor, Windowsill Herb Garden, Grow Your Own Herbs from Organic Seeds (Basil)

(786)
$69.15$33.51
FREE delivery Jun 13 - 17
Loading...
9 Herb Indoor Window Garden Kit - House Plants Seeds - Best Unique Gift Ideas for Women, Mom, Friend, Her, Birthday, Housewarming, Mother - New Home Kitchen Gifts - Live Plant Starter (Burlap Pots)

9 Herb Indoor Window Garden Kit - House Plants Seeds - Best Unique Gift Ideas for Women, Mom, Friend, Her, Birthday, Housewarming, Mother - New Home Kitchen Gifts - Live Plant Starter (Burlap Pots)

(1,917)
$35.99
PrimeFREE delivery Sat, Jun 14
500+ bought in past month
Loading...
Viabrico 10 Pack AF-100 Replacement Spool Line for Black+Decker - 0.065" Weed Eater String Trimmer Line Spool, 30ft Autofeed Weed Wacker Spool Refill for Black+Decker(8 Spool,2 Cap,2 Spring)

Viabrico 10 Pack AF-100 Replacement Spool Line for Black+Decker - 0.065" Weed Eater String Trimmer Line Spool, 30ft Autofeed Weed Wacker Spool Refill for Black+Decker(8 Spool,2 Cap,2 Spring)

(142)
$16.99
FREE delivery Wed, Aug 20 on your first order
500+ bought in past month
Loading...
Hedge Trimmer Cordless for Dewalt 20V MAX Battery (No Battery), 22 inch Electric Bush Shrub Edge Trimmer, Brushless Motor, Powerful & Lightweight, 4.4LBS

Hedge Trimmer Cordless for Dewalt 20V MAX Battery (No Battery), 22 inch Electric Bush Shrub Edge Trimmer, Brushless Motor, Powerful & Lightweight, 4.4LBS

(0)
$139.00
FREE delivery Sun, Aug 10
Loading...
Neck Massager, 2026 Updated Bionic Heated Deep Tissue Massager, Wireless Electric Cervical Neck Massager, Kneading Massager, Electric Kneading Massage Pillow, Rechargeable USB-C

Neck Massager, 2026 Updated Bionic Heated Deep Tissue Massager, Wireless Electric Cervical Neck Massager, Kneading Massager, Electric Kneading Massage Pillow, Rechargeable USB-C

(0)
$79.98
FREE delivery Dec 15 - 22Arrives before Christmas