Basic Conditional Formatting in Google Sheets

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: • Advanced Conditional F...
✉️ Google Sheets Tips Newsletter, my free weekly newsletter:
www.benlcollins.com/google-sh...
#googlesheets #googlesheetstutorial #spreadsheet

[@Scott-sm9nm]

I *absolutely* loved that! In my conditional format that is always on 1 column or 2+ like data type columns, I would use B1:C where leave off the ending 'lower right' row number. So that if I add rows then they automatically get conditionally formatted. Learned some good tips and will check out the advanced ones.

[@benlcollins]

Thanks, Scott!