HomeHow ToHow to Highlight Blank or Error Cells in Google Sheets with Conditional...

How to Highlight Blank or Error Cells in Google Sheets with Conditional Formatting

Author

Date

When you have a lot of data to organize, what better way to do so than use Google Sheets. If you are familiar with using Microsoft Excel worksheets, Google Sheets will be a breeze. Both applications apply almost the same spreadsheet rules and formattings. You can input as much data as you want while maintaining a clean and orderly look.

Google Sheets allow you to save your documents on your Google Drive cloud storage for free. So, even when you have to access all your data from another device, it is possible in just a few seconds with the dedicated mobile app or through the website.

Now, we cannot sometimes help making an error when we input numbers or formulas on Google Sheets spreadsheets. There are times when we left out a cell blank or empty in a certain row without any inputted value on it. These mistakes are easily spotted when you have only a few numbers and text to add to your Google Sheets.

But, what if you have hundreds or thousands of data you have to input on Google Sheets? Will you be able to see these errors and blanks or leave them unnoticed?

Steps-to-Highlight-Select-Errors-or-Blanks-with-Conditional-Formatting-on-Google-Sheets
Screenshot: Windows Dispatch

Steps to Highlight & Select Errors or Blanks with Conditional Formatting on Google Sheets

Google Sheets make it easier for you to notice cells with errors and blanks. All you have to do is to set the automatic highlight of these cells as they happen so you don’t leave them wrong. You can do so by accessing the Conditional Formatting settings and change the values to your needs.

Through the Conditional Formatting tool on Google Sheets, you can custom set each cell to fill a specific color or font style when there are blanks or errors on it. That way, they stand out on your sheet and allow you to spot them easily.

Select or Highlight Blank Cells on Google Sheets

How-to-Select-or-Highlight-Blank-Cells-on-Google-Sheets
Screenshot: Windows Dispatch
  • First, launch your Google Sheets Workbook.
  • Look for the cells that you want to highlight. Select them all.
  • On the menu bar, click Format.
  • Scroll down and select Conditional Formatting.
  • Go to the Single Color tab.
  • Under Apply to range, make sure you have all the cells that you have to highlight.
  • Scroll down to Format Rules and click the drop-down arrow.
  • Select Is Empty.
  • Under Custom, you can select the formatting such as the font color, style, and fill.
  • Click Done.
  • It will then highlight all the blank cells in your selected range.

Select or Highlight Cells with Errors on Google Sheets

How-to-Select-or-Highlight-Cells-with-Errors-on-Google-Sheets
Screenshot: Windows Dispatch
  • On your Google Sheets workbook, navigate to Format and select Conditional Formatting.
  • Make sure you are under the Single Color tab.
  • Under Format Rules, click the arrow and select Custom Formula Is.
  • Now, enter the following: =ISERROR(B1). You can change B1 to any beginning cell in your range.
  • Choose the formatting style under Custom.
  • Click Done.
  • If there are cells with errors, it will apply your selected formatting.

That’s it! Now, you can immediately spot cells in your workbook that has an error or are empty. Are the conditional formatting methods useful in organizing and making you more productive with Google Sheets spreadsheets? You can share your story with us in the comments below.

Related

More From

How to Reset the Settings App in Windows 10 or 11 PC

Whenever you want to customize your Windows OS, you can do so via the Settings app. You can change the languages, add security, improve...

How to Set Parental Controls with Xbox Family Settings on Xbox One

A lot of kids dreamed of playing Xbox games. For many children, such a dream came true when they were given Xbox One consoles....

How to Queue & Send Microsoft Teams Messages while Offline

Sending chat messages online is easy and fast, much like sending a text message on your phone. Your recipients can receive it in real-time...

How to Install Firmware Update to Surface Earbuds

Microsoft has just entered the true wireless earbuds (TWE) battle arena with the introduction of Surface Earbuds. This very competitive space is being shared...

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Recent Articles

Stay Connected

Trending