Instructions for highlighting blank cells in Google Sheets

To easily identify blank cells in Google Sheets, it is recommended to highlight those cells similar to how you highlight blank cells in Excel. This will help you count cells containing text in Google Sheets. Highlighting blank cells in Google Sheets does not affect the data values in the spreadsheet, but only changes the visual appearance by adding color to the cells. Here is a guide on how to highlight blank cells in Google Sheets.

How to highlight blank cells in Google Sheets

Step 1:

First, we create a data table in Google Sheets as usual. Then, we select the data table in Google Sheets and click on “Conditional formatting” in the displayed menu.

Step 2:

Look to the right side of the screen, and you will see the formatting interface for data using colors. Under “Apply to range,” you will see the selected data range. Next, under “Format rules,” click on it and select “Is empty.”

Step 3:

Next, under “Format style,” click on the paint bucket icon to choose a color for the blank cells in Google Sheets.

Click on the colored circle that represents the color you want to use for the blank cells in Google Sheets. If you want to choose a different color, click on “Custom” instead.

Step 4:

Now, you will see a color palette to choose the desired color for the blank cells in Google Sheets. Once you have selected the color, click OK to save the new color.

Step 5:

Finally, click on Done below to save the formatting for the data table in Google Sheets.

You will see that the blank cells in Google Sheets have been highlighted with the chosen color, as shown in the image below, making it easier for you to observe.

Leave a Comment

Your email address will not be published. Required fields are marked *

Shopping Basket
Scroll to Top