In this tutorial, you will learn how to highlight cells using conditional formatting based on another cell in Google Sheets. This can be done using the custom function option in conditional formatting.
Ready to discuss conditional formatting in Google Sheets? Below, I’m providing step-by-step instructions on the process, including color gradient (scaling), using a checkbox, highlighting information, and much more. I’ve created the most straightforward conditional formatting Google Sheets guide so you can discover everything about this critical spreadsheet function. Using Excel? Check out our Using Excel
Formatting data and making it look good and more readable is something we often do when working with Google Sheets. And Google Sheets has a tool that makes copy-pasting of formatting really easy. It’s the Format Painter tool (called the Paint Format in Google Sheets). Once you have applied the formatting to a cell or
How do you count not-blank cells in a spreadsheet? I’ll show you. In Google Sheets, the COUNTA and COUNTIF functions allow you to count cells if they’re not blank. You just have to tell them what you’re looking for. I’ll break down these functions’ syntax, and I’ll show you exactly what to enter. That way,
This guide show how to highlight duplicates in Google Sheets. Note that you can do this in several ways, but the simplest is to use a custom formula in the conditional formatting menu. I’ll also show you how to highlight duplicates with the COUNTIF formula. Follow along below for the step-by-step highlighting guide, the syntax
I can’t overstate the value of INDEX MATCH in Google Sheets. While there are several functions designed to look up data, these are two of the most powerful. Used on their own, the INDEX and MATCH functions have limited applications. However, they become exceptionally powerful when combined. The INDEX MATCH function helps me evaluate a
Adding phone numbers into Google Sheets — without formatting — can quickly become overwhelming. Thankfully, there’s an easy way to customize your Google Sheets phone number format. The quickest way is to click select the following in the top menu bar of your Google Sheet: “Format” > “Number“ > “Custom Number Format.” In this guide, I’ll show
With over 6 million businesses using Google Workspace, you can expect them to seek out professionals who know how to use relevant tools like Google Sheets and Forms. These two tools are handy for conducting market surveys and data analytics. Acquiring skills in spreadsheets and forms doesn’t only open employment opportunities, though. Mastering these two
Whether you’re in charge of trivia night or a fantasy league, it’s straightforward to make a bracket template in Google Sheets. Whether you’re looking for a free downloadable bracket template for Google Sheets for an upcoming tournament or want to learn how to make a tournament bracket in Google Sheets from scratch, our step-by-step guide
To-do list apps dedicated to task management are convenient, but they aren’t always practical. Maybe you’re working on a project with a team and need to share the list. Maybe you want to print a list and keep it on your fridge. Creating a to-do list in Google Sheets lets you customize it to fit your
Tons of people around the world use spreadsheets on a daily basis. There are quite a few spreadsheet apps out there, but two that have risen most to prominence are Microsoft Excel and Google Sheets. Both apps are great and serve their purpose well, but there are a few key differences when you look closer
The integrity of your data when performing calculations is incredibly important. Google Sheets data validation can help you ensure all of the values you input meet certain criteria to make sure all your calculations aren’t for naught. Using Google spreadsheet validation puts light restrictions on the entered data to provide accurate and consistent work from
Ready take your Google Sheets skills to the next level? Want to lift your productivity without breaking a sweat?
Sign up for our free newsletter for regular spreadsheet guidance.
Enjoy our custom-made Google Sheets templates for free via email access
