Custom Formula Conditional Formatting Rules

Описание: In this lesson we look at custom formulas for conditional formatting. This allows you to make custom conditional formatting rules with a formula based on a boolean (true/false) condition.

--
Current Section:
➡️Section 7: Conditional Formatting
https://docs.google.com/spreadsheets/...


Previous Sections:
✅Section 1: Organization
https://docs.google.com/spreadsheets/...

✅Section 2: Formula Building
https://docs.google.com/spreadsheets/...

✅Section 3: Data Validation
https://docs.google.com/spreadsheets/...

✅Section 4: Sharing
https://docs.google.com/spreadsheets/...

✅Section 5: Numbers
https://docs.google.com/spreadsheets/...

✅Section 6: Functions
https://docs.google.com/spreadsheets/...

--

🗣️Socials:
WEBSITE: https://matttechtidbits.github.io/mat...
REDDIT:   / matttechtidbits  
INSTAGRAM:   / matttechtidbits  


Need a Freelancer? Check out my Upwork Profile:
https://www.upwork.com/freelancers/~0...

–
⏳Timestamps:
(00:00) Introduction
(00:48) Foundations of Custom Formatting Rules
(01:21) Building a Custom Formatting Rule Formula
(03:29) Cell References Makes a Difference!
(06:17) Range Must Match the Formula
(08:31) Highlight a Range Based on a Dropdown
(11:01) Troubleshooting Common Issues
(11:37) Highlighting Entire Row
(12:40) Highlight Based on Checkbox
(15:43) Conclusions / End Slides

🎵Music is "WFH" made by me with my solo music project name,
@Ambiosynthesis
   • WFH  
—
Tags:
#googlesheets
#spreadsheet
#technology
#sheets