Google Sheets Tutorials · Better Sheets

Create easter eggs in your sheets.

DarkSide of Google Sheets - Creating Dark Mode and Making it Better!

Create dark mode with Conditional Formatting.

200 REGEXMATCH Examples in Google Sheets

Uncover the Magic of Regex Match! 🎩✨ Explore 200+ Examples at BetterSheets.co. Validate emails, detect hashtags, format data & more! Dive into the world of Regular Expressions. Start Your Regex Journey Now!

Use REGEXMATCHER to generate any REGEXTMATCH formula you want.

Conditional Formatting Advanced Data validation

Project Based Task Management

Create a better checklist for project based task management.

Conditional Formatting Beginner

10 Things I Hate About Your Spreadsheets

10 Things I Hate About Your Spreadsheets and how to fix them. Here is a list of 10 things you can do today to make your sheets more lovable.

The 10 Things I Hate about your Sheets

Squeezed Rows
Garbage Data
Looks The Same
Crazy Column Width
Where’s Waldo
Of Results
Too Many Clicks
Instructions Unclear
Eye Strain and Headaches
Lazy Conditional Formatting
Too Many Cells

Conditional Formatting Beginner Data validation

Create Your Own Pride Flag Easter Egg in Sheets

If you type the letters of PRIDE in the first 5 columns in the first row of your sheets they'll turn the color of the pride flag. If you want to create your own easter egg in sheets then follow along this step-by-step tutorial as I show you how.

This might be better than Conditional Formatting! We're using the onEdit() simple trigger in Apps Script..

Conditional Formatting Advanced

Highlight Row as You Move Your Cell Selection

Checking data? This script changes bg color of entire row as you move your cell selection.

Conditional Formatting Beginner

Create A Video Course in a Google Sheet | LMS in a Google Sheet

Set up a list of video links, and a checklist for others to use.

Conditional Formatting Intermediate Data validation

Anders Asks: Can I Highlight Whole Row if Certain Columns have text?

Yes, using conditional formatting we can do this.

Conditional Formatting Beginner

Add a Checkbox to Turn on Dark Mode

Get ready to shake things up, formula fanatics! Learn how to add a dark mode button to your Google Sheets with this dead simple trick. Using conditional formatting and a custom formula, you can turn on dark mode with just one click. Don't miss out on this cool feature! Made this really quick dark mode click button. And I wanted to show you how I did it because it's dead simple, super simple. It's literally just using conditional formatting

Conditional Formatting Beginner

Rishabh Asks: Conditional Format Whole Row Via Text inside a Cell

Your question is, you have these events and dates and statuses. And you want to turn them green actually you wanna turn them any, some color, the whole entire row based on if in this D column the status is closed.

Conditional Formatting Intermediate

11Google Sheet Tutorials

Discover the Power of Productivity with Our Exclusive Library of Google Sheet Tutorials!

Why Choose Our Google Sheet Tutorials?

🚀 Maximize Your Efficiency:

🎯 Precision at Your Fingertips:

💡 Expert Tips and Tricks:

🔧 Google Script Magic: