How to Highlight Blanks or Errors in Google Sheets


When you’ve got a Google Sheets spreadsheet full of information, it may be troublesome to see sure cells at a look. If you’ve got empty cells the place you anticipate knowledge or errors generated from formulation, you’ll be able to routinely spotlight them.

Google Sheets offers useful features to make knowledge entry and evaluation simpler. One such function is conditional formatting. With it, you’ll be able to configure your cells to comprise a fill coloration or particular font type, coloration, or format when situations like blanks or errors happen.

Automatically Highlight Blank Cells in Google Sheets

The course of for setting up conditional formatting for blanks in Google Sheets solely takes a couple of clicks. So, head to Google Sheets, signal in, after which open your workbook and sheet.

Select the cells the place you need to apply the highlighting. You can do that simply by choosing the primary cell and dragging by way of the remaining. Then, click on Format > Conditional Formatting on the menu.

Click Format, Conditional Formatting

This opens the Conditional Format Rules sidebar, which is prepared to your new rule. If you’ve got different guidelines arrange already, you’ll want to click on “Add Another Rule.”

Click Add Another Rule

In both case, ensure that the Single Color tab is chosen.

At the highest of the sidebar, affirm the cells that you really want to apply the rule to in the “Apply to Range” field. You could make changes right here if wanted.

Confirm the cells in Apply To Range

Next, go down to the Format Rules part. Click the “Format Cells If” drop-down field and select “Is Empty.”

Select Is Empty

In the Formatting Style space, select the formatting that you really want to use to spotlight the clean cells. You can choose a font type, coloration, or format, or use a fill coloration for the cells. And you’ll see a preview in the field above the formatting choices. For our instance, we’ll use an orange fill coloration.

Select your formatting and click Done

When you’re completed, click on “Done.”

Take a take a look at the cells the place you utilized the rule and provides it a check should you like. You ought to see your clean cells pop with the formatting that you just chosen.

Google Sheets conditional formatting for blank cells

Automatically Highlight Errors in Google Sheets

For highlighting errors in Google Sheets, you’ll comply with the same course of. However, there isn’t a built-in choice for this like there may be for empty cells, so that you’ll truly enter a operate of kinds.

Follow the identical preliminary steps as described above by choosing the cells, clicking Format > Conditional Formatting from the menu, and selecting the Single Color tab on the prime of the sidebar.

Confirm the vary of cells in the “Apply to Range” field.

Confirm the cells in Apply To Range

Click the “Format Cells If” drop-down field and select “Custom Formula Is.” In the field that seems, enter the next and substitute the cell reference in parentheses along with your starting cell:

=ISERROR(A1)

Enter the custom formula for errors

In the Formatting Style part, choose the formatting that you really want to use to spotlight the cells with errors. When you end, click on “Done.” For this instance, we’ll use purple daring textual content.

Select your formatting and click Done

Review the cells the place you utilized the rule and check it if you want. You ought to see cells containing errors show with the formatting that you just chosen.

Google Sheets conditional formatting for errors

For different methods to make your spreadsheets simpler to learn, check out how to alternate row or column shading in Google Sheets.





Source link

This Web site is affiliated with Amazon associates, Clickbank, JVZoo, Sovrn //Commerce, Warrior Plus etc.

Related Posts

Leave a Reply

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

error

Enjoy this blog? Please spread the word :)

Follow by Email
Pinterest
LinkedIn
Share
WhatsApp