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.
Use the contact page or email support@yourdomaincoursehive.io
Yes! The courses are suggested by the community itself. At the bottom of the page, you’ll find a form where you can suggest a course.
No. We are a learning hub that organizes and curates YouTube courses. Certificates are for participation, not formal accreditation.
Not directly. Only YouTube courses are featured, but you can suggest new ones through our form.
If the YouTube video includes them, you’ll see subtitles or closed captions.
Yes. Once logged in, your progress is saved in the cloud and accessible from any device.
No. Free certificates are included with every free course.
Please report it using the support form or email so we can update or replace the course.
