In this video, we do a deep dive into the essential features of conditional formatting. We cover all the rules except for "Custom formula is" (check out the advanced video for that one!) as well as how to copy rules and even turn off the conditional rules but keep the formatting.
📖 Chapters:
0:00 - Introduction
1:28 - Empty / Not empty
3:48 - Text conditions
5:55 - Date conditions
9:15 - Number conditions
11:25 - Rule order precedence
12:18 - Copy conditional formatting rules to another dataset
14:27 - Convert conditional formatting to permanent formatting
🎥 Related video:
Advanced Conditional Formatting in Google Sheets: https://www.youtube.com/watch?v=LsX2tgRfC_k
✉️ Google Sheets Tips Newsletter, my free weekly newsletter:
https://www.benlcollins.com/google-sheets-tips/
#googlesheets #googlesheetstutorial #spreadsheet