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
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.
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.”
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.
Next, go down to the Format Rules part. Click the “Format Cells If” drop-down field and 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.
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.
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.
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:
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.
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.
For different methods to make your spreadsheets simpler to learn, check out how to alternate row or column shading in Google Sheets.
This Web site is affiliated with Amazon associates, Clickbank, JVZoo, Sovrn //Commerce, Warrior Plus etc.