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-conditional-formatting-tricks/
to download the example workbook or know more about these tricks.
#ExcelTricks #ConditionalFormatting
Continue this lesson in the app
Install CourseHive on Android or iOS to keep learning while you move.
FAQs
We curate free YouTube courses, organized by category and language — and make it easy for you to track your learning progress.
Yes. Free courses are embedded YouTube videos.
Currently available in English — with Portuguese, Spanish, French, German, and Italian coming soon.
Check ratings, reviews, duration, and description.
All courses include a certificate of participation.
Yes, an account lets you track progress, earn certificates, and save favorites.
We auto-save your watch position so you can resume on any device.
