How to Highlight Blank Cells in Google Sheets Using Conditional Formatting

When collecting responses, auditing financial reports, or importing raw CSV data into Google Sheets, missing records and empty cells can break downstream formulas and distort statistical averages. Scanning thousands of rows manually to locate unpopulated fields is tedious and error-prone. By applying Conditional Formatting rules, you can configure Google Sheets to automatically highlight empty cells with distinct background colours, making incomplete records stand out instantly for quality control.

Highlighting Blank Cells Using the Built-In Rule Preset

Google Sheets includes a native preset designed specifically to identify unpopulated spreadsheet cells without writing custom formulas.

1. Open your spreadsheet in Google Sheets.
2. Select the data range you want to audit (for example, highlight cells A2:E100). Click the top-left column header and drag across to select multiple columns.
3. Click the Format menu on the main toolbar and select Conditional formatting.
4. The Conditional format rules panel will open on the right side of the screen.
5. Under the Format rules section, click the drop-down menu labelled Format cells if….
6. Scroll down and select Is empty.
7. Under Formatting style, choose your preferred highlight colour (such as a soft red or light yellow fill) from the fill bucket icon.
8. Click Done to activate the rule.

Every cell within the selected range that contains no value, text, or formula output will instantly turn the specified background colour. As users fill in missing data, the highlight removes itself in real time.

Highlighting Entire Rows Containing Missing Values

Highlighting only the empty cell can sometimes be difficult to track in wide datasets. To highlight the entire row whenever a critical column (such as Email Address in Column C) is blank, use a custom formula rule:

1. Highlight your full table range including all columns (e.g. A2:F100).
2. Open Format > Conditional formatting.
3. Set the Format cells if… drop-down to Custom formula is.
4. Enter the following formula, locking the column with a dollar sign:
   =ISBLANK($C2)
5. Select your formatting fill colour and click Done.

The dollar sign ($C2) locks the evaluation to Column C across every cell in the row. If cell C2 is empty, the entire row from A2 through F2 will be highlighted.

Handling Cells with Hidden Spaces or Formula Errors

Cells that appear empty but contain invisible space characters or empty formula strings ("") will not trigger the ISBLANK rule. To capture both genuinely blank cells and whitespace-padded entries, use this robust custom formula:

=LEN(TRIM(A2))=0

This formula strips invisible spaces before checking string length. If the cell contains only spaces or blank text outputs, it evaluates to zero and triggers the formatting highlight reliably.