Скачать с ютуб Advanced Conditional Formatting in Google Sheets в хорошем качестве

Advanced Conditional Formatting in Google Sheets

In this video, we do a deep dive into the advanced features of conditional formatting, focussing on the "Custom formula is" rule. Learn how to use conditional formats across entire rows when a condition is met. Then we'll look at conditional formats down columns, identify duplicate entries, multi-condition rules, date rules, search rules, look ups to other sheets, and more. 📚 Additional resources: - Conditional Formatting blog post: https://www.benlcollins.com/spreadshe... - CHAR function blog post: https://www.benlcollins.com/spreadshe... - Custom Number Format blog post: https://www.benlcollins.com/spreadshe... - Custom Number Format rule: [color50]$#,##0 ▲;[color3]-$#,##0 ▼;[blue]$0 ▬ - REGEX functions blog post: https://www.benlcollins.com/spreadshe... - REGEX Cookbook course: https://courses.benlcollins.com/p/goo... 📖 Chapters: 0:00 - Introduction 1:53 - How the "Custom formula is" rule works 8:37 - Format entire row 10:22 - Conditional formatting with checkboxes 11:53 - Conditional rule precedence 12:35 - Identify duplicates with conditional formatting 18:11 - Format entire columns 19:28 - Multiple conditions in conditional formatting 21:33 - Custom date rules 23:52 - Number comparison conditional formatting rules 25:10 - Custom Number Formats method 27:04 - Text matching 31:24 - Conditional formatting with lookup formulas and data in different sheets 35:29 - Secret bonus rule for you...shhh! 🎥 Related video: Basic Conditional Formatting in Google Sheets:    • Basic Conditional Formatting in Googl...   ✉️ Google Sheets Tips Newsletter, my free weekly newsletter: https://www.benlcollins.com/google-sh... #googlesheets #googlesheetstutorial #spreadsheet