📊 ADVANCED Excel Tutorials - Change color when date changes ~ Powerful Conditional Formatting Trick 💡

Bored with ZEBRA lines? You can use conditional formatting to create a crazy rule to change color whenever there is new date. This is a powerful but elegant way to visualize spread of data. Sample workbook 📗👇 =================== Please download the sample workbook from here - https://chandoo.org/wp/wp-content/uploads/2021/12/color-change-on-date-change.xlsx In this video (topics) ⏱👇 ===================== 0:00 - Introduction to the color changing data problem 0:39 - Why Table formatting (CTRL+T) won't work 1:10 - Setting up the CF formula based rule 3:15 - Testing and adding "other color" 3:54 - Explanation of the UNIQUE(...) & COUNTA formulas More tricks on Conditional Formatting: =============================== Top 5 Conditional Formatting tricks - https://youtu.be/gpbwBxTRYRM Highlight overdue items with CF in Excel - https://youtu.be/mAOAAQoN4h8 Top 30 Advanced Excel tips & tricks - https://youtu.be/m2C_-6PW6WE #ExcelTrick