Hey there stranger!

Sign up to get access.

Add a Checkbox to Turn on Dark Mode

About this Tutorial

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

Video Transcript

 Hey, sheet shakers, formula fanatics, still working on the name for ya. 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 and it's, it's really doing a little trick. And I wanna show you that trick.

So I'll show you what happens. So I can just click this box if I want to turn.

I can even even message to dark mode. Say dark mode is on. So now turn on dark mode.

Dark mode. So I did, this is with conditional formatting. This is a if statement just to do the text that all this if statement is saying is true. Say dark mode is on if false, turn on dark mode. That's it. Everything else is a conditional formatting and I'll show you right now so I, I can let's do this format.

Additional formatting.  and all I say here is I use a custom formula and if you don't know my other, if you haven't watched any of the other conditional formatting videos, I talk about custom formula. This first equal sign is a little confusing. This first equal sign is, this word is so really custom formula is, and now we're gonna put the cus the formula.

And what I did is dollar sign, B dollar sign three equals. . And what that does is it says in B3 is the checkbox. So every single one of these cells, this is applying to the entire range of this entire sheet. Every these cells is like b3. This custom formula is actually relative, but I put these dollar signs to say no, no matter where you are on the sheet, whatever cell you're.

Look at b3. Okay? That self to have start. What happens if I take off this dollar sign? Let's do this.

So now turn mode and. Changes A one. Why is that? Well, because it's relative. So this b3, if I don't put in the dollar sign, like dollar sign holds the B, it holds a three and it doesn't change it. It's very much like a formula. If I wanna do equals. Let's show you this

equals b3 and that'll be true. And if I move this down, this formula will mo move to B four. Okay? So if I, but if I hold equals and equal, And I move it down, it, it doesn't change. I can copy paste this all the way down and see, this is funny because this is relative. Every single one of these cells is looking two one to the right and then down to for true.

And it's saying if it's true, every single one of these cells is looking down towards b3. So if I now.

you can see it working. It's, it's now, okay, now every single cell is gonna go over here to b3. Done. Now they're ignoring every other cell. Here's one challenge I will tell you about that I experience when using a lot of conditional formatting. We were sort of using conditional formatting to.  change the status color.

So we had like a CRM in the STA and in a status column, we wanted to change the color. And so we had this incredibly long, it was a, I think about 20 conditional formats to say, okay, if it's this, change it here. If it's this, change it to this. And you know, a lot of statuses, well, what happened is, We sort of got to a point where every single edit and change it was looking at that conditional formatting and then taking a lot of time, like everyone's Chrome browser was getting really slow.

Every single time you would edit, that will happen. So that is just one thing to look out for if you are using conditional format overboard. Turn. Wanted to add this really cool little, really, really turn on dark mode button for people. How you do it? Just conditional form. Then you get a little bit, I wouldn't, I wouldn't use this all the time, but it's a fun thing to add to your Google sheets.

Bye.

Courses

Sheet Stories / Video Notes + ADDED: Email Notifications

00:00:00

Fast FAQS

ChatGPT Clone in Google Sheets Part 2

Create an Internal Google Sheets Add-on

Why Different Cell References in AI Integration in Sheets?

Show Sheet Tabs Based on Edit

Add Title Case to Google Sheets

Getting Started Coding in Apps Script

How to Power Testimonials with Google Forms and Sheets

Seek Errors When Coding Apps Script

Think Like a Programmer: Develop The Mindset of an Apps Script Coder

ChatGPT Clone in Google Sheets Part 1

Embed a Number in a Website from a Google Sheet

Create Navigation Like A Book or Presentation

Add Click Tracking To Your Google Sheets | Bitly in a Google Sheet

00:29:08

Hold a Giveaway Raffle in a Google Sheet

Capture Emails from Website Form to a Google Sheet (Without Zapier)

Embed a Headline in a Website from Google Sheets

Quickstart Tutorial OpenAI API in Google Sheets

Create a new Spreadsheet from just a Name in a Sheet.

00:05:21

Bjarne Asks: Can I show the Last Time of the Last Edit in a sheet?

00:05:43

Email Yourself a Cell from a Google Sheet, Every Day

OpenSea Data Inside Sheets

Create an Email Campaign Stats Calculator

00:35:13

Twitter App Clone in a Google Sheet

Dylan Asks: How to Automatically Delete Rows If Cell Contains Value

Highlight Row as You Move Your Cell Selection

Create a Timer with Apps Script

LinkTree in a Google Sheet

00:11:22

Password Protecting Data In a Google Sheet

Automatic Weekly Backup of Google Sheets

Create a CPM Custom Function (Create Better Calculators!)

Move Entire Row when a Cell is changed to "Yes" - The $75,000 Google Script

00:12:29

What Can You Automate in Google Sheets? Every single trigger available to Google Sheet users

Sync Two Tabs Without ImportRange()

Google Sheets Stories? No! But we'll add timestamped video notes to your google sheets.

00:00:00

Password Protecting Data In a Google Sheet Part 2 The Basics

Benoit Asks: How to Convert Case

00:07:35

Learn to Code in Google Sheets, For Programmers

Add a Checkbox to Turn on Dark Mode

00:05:10

Write Your First Script

00:08:31

Find Keywords in Any Column. Create quick search dropdown to find keywords

00:09:37

Basic CRM - Add a Powerful Script To Move Row Based on Status

How To Improve: 1,000 Business ideas: Business Idea Generator

00:11:20

Let's Make a Bookmarklet!

00:12:37

Troubleshooting Bitly in a Google Sheet Script

00:07:07

Unique Features - Design a Better Dashboard Part 2

00:04:13

How To Set Up Stripe Webhook to Google Sheets with Google Script

00:22:10

How to Edit a Macro

00:08:22

Sheet Stories / Video Notes + Clear 24 Hour Old Videos

00:35:10

Add A Timestamp to Task Lists (without Now Formula)

00:07:44

Make your Custom Functions Like Native Functions | Custom Function Autocomplete

00:17:58

Create a Changelog Between 2 Cells Custom Function | To learn Double For Loop

00:23:26

New Syntax for WhatChanged Formula in Google Script

00:07:14

How to Record Macros

00:06:20

2 Ways to Delete Lines Quickly (CAREFUL, it's a script!)

00:09:53

Deep Inside Dark Habits Google Script

00:18:54

How to Trigger Macros Daily

00:06:58

5 Ways to Create Coupon Codes | Create UUIDs

Create a Radio Button From Checkboxes Using Google Apps Script

00:15:01

Better Than Happy | Redesign of The Feelings Wheel

How Starter Story Designs Data

Learn to Love Your Sheets

Best Header Font Ever

Sheet Review! 150 Active VCs by LemonIO

Anika Asks: How To Set Text Overflow All The Time

Introducing: Brutal Calendar

Add a Checkbox to Turn on Dark Mode

00:05:10

Create Drop Shadows! This makes your dashboards pretty.

00:12:04

Merge Cells for Dashboards

00:05:29

10 Things I Hate About Your Spreadsheets

Dark Mode / Better Font Color

00:09:35

Better Font Colors

00:02:45

Magical Things You Can do with Checkboxes in Google Sheets

00:12:31

How To Export Your Beautiful Sheets to PDF

00:04:06

Consider Labels as Opposed to Headers

00:04:02

Add Icons To Your Sheets With a Domain Name

00:04:21

How To Color Cell Blocks So Others Enter Data Easily

00:10:30

Great Sheets! Corona Hiring Sheet

00:10:43

Great Sheets! Community Information Board by Seedtable.com

00:07:35

Roast: Hotel PPC Channel Cost Calculator

00:11:25

Better Header Fonts - Best Fonts To Use In Google Sheets

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

00:09:49

Basic Keyboard Shortcuts To Speed Up Your Productivity

00:13:44

Basics - 5 Ways to Change Row Height

00:05:08

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

00:09:31

How to Refer to Other Cells - A1 and R1C1 Explained

00:13:22

Change the Default Font

00:03:33

Biggest Flaw In Dashboards with Dark Colors

00:07:45

Basics - 4 Ways to Change Column Width

00:05:48

Basics - Structure of a Sheet: Index() Row() and Column()

00:06:49

Communicate Better with Gridlines, Border Styles, and Border Colors - Google Sheets

00:08:55

Use Cmd + Y To Do It Again, and Again, and Again

00:03:03

Create an Auto-Update Sales Chart: Trailing 12 Months

00:09:57

Google Sheet Basics - The Absolute Basics

00:09:48

Secure Your Sheets by BetterSheets.co

00:11:07

How To Create An AutoFill in Google Sheets

00:06:07

Build a Thermometer for Savings Goals

Make Your Lists Spicy Hot in Google Sheets

00:01:47

Restrict Access to a Cell if Another Cell is Blank

How to Use Smarket

00:03:28

Combine Data from a Tab and a Totally Different Sheet | ImportRange and Curly Brackets!

00:06:23

Job Application Tracker Template | From TheLandOfRandom - Sheet Improvement!

00:53:31