5 *Must have* Excel Conditional Formatting Tricks

My love affair with Excel Conditional Formatting began almost 12 years ago when I first used it to create an awesome project plan. In this video let me share some of my favourite secrets about it. You will learn, 0:00 - Introduction 0:45 - Icons, but not too many 3:28 - Highlight entire row 5:31 - Zebra shading, advanced zebra shading 9:55 - Relative dates (dates before today, next week or last week) 13:17 - Databars & Icons in the same cell Please visit https://chandoo.org/wp/5-useful-condi... to download the example workbook or know more about these tricks. #ExcelTricks #ConditionalFormatting

Join Today
Data cleaning in Excel - 10 tricks *PROs* use all the time
▶︎

Data cleaning in Excel - 10 tricks *PROs* use all the time

Four SMART Ways to use Custom Formatting instead of Conditional Formatting in Excel - Part 1
▶︎

Four SMART Ways to use Custom Formatting instead of Conditional Formatting in Excel - Part 1

These are the most important Excel Text Functions you *NEED* to know
▶︎

These are the most important Excel Text Functions you *NEED* to know

Excel for Finance and Accounting Full Course Tutorial (3+ Hours)
▶︎

Excel for Finance and Accounting Full Course Tutorial (3+ Hours)

5 Advanced Tips on how to use IF formula in Excel that will SURPRISE you 😲
▶︎

5 Advanced Tips on how to use IF formula in Excel that will SURPRISE you 😲

Data Cleaning in Excel - 10 Tricks (Beginner to PRO)
▶︎

Data Cleaning in Excel - 10 Tricks (Beginner to PRO)

Microsoft Excel 2021/365 Tutorial: 3.5+ Hours of Advanced Excel Training Course
▶︎

Microsoft Excel 2021/365 Tutorial: 3.5+ Hours of Advanced Excel Training Course

5 Conditional Formatting tips to make you a rock star at work 🤘
▶︎

5 Conditional Formatting tips to make you a rock star at work 🤘

You're ONE DOT Away from Cleaner Excel Reports | Before vs. After TRIMRANGE
▶︎

You're ONE DOT Away from Cleaner Excel Reports | Before vs. After TRIMRANGE

How I easily deal with 100s of columns in Excel ~ PRO Trick💡
▶︎

How I easily deal with 100s of columns in Excel ~ PRO Trick💡

777 Portal ✨ Manifest Miracles, Abundance & Divine Alignment - Meditation Music
▶︎

777 Portal ✨ Manifest Miracles, Abundance & Divine Alignment - Meditation Music

19 Excel Shortcuts you NEED to use more [with FREE PDF 📃]
▶︎

19 Excel Shortcuts you NEED to use more [with FREE PDF 📃]

The Most Powerful Manifestation Technique ... It Works So Fast It's Scary.
▶︎

The Most Powerful Manifestation Technique ... It Works So Fast It's Scary.

FILTER Function Hacks That Save Hours of Work
▶︎

FILTER Function Hacks That Save Hours of Work

Five Amazing Conditional Formatting Tips That You Don't Know
▶︎

Five Amazing Conditional Formatting Tips That You Don't Know

Learn VBA & Excel Macros in 20 minutes - with code samples 👨‍💻
▶︎

Learn VBA & Excel Macros in 20 minutes - with code samples 👨‍💻

The Excel Pagination Trick That Makes Reports Unlimited
▶︎

The Excel Pagination Trick That Makes Reports Unlimited

My Son-In-Law Has No Idea I Own The Company He Works For As CEO. Dad Journey.
▶︎

My Son-In-Law Has No Idea I Own The Company He Works For As CEO. Dad Journey.

6 Must have line charts for business data analysis 📈👌
▶︎

6 Must have line charts for business data analysis 📈👌

I asked 6 Excel experts to share their *BEST* tips & tricks 👌
▶︎

I asked 6 Excel experts to share their *BEST* tips & tricks 👌