Guia do Excel

How to highlight blank cells in Excel

Highlighting blank cells is a great way to quickly identify missing data or incomplete records in your spreadsheets.

Passo a passo

1
Select your range
Highlight the range of cells or the entire table where you want to find blank cells.
2
Abra a Formatação Condicional
Go to the 'Home' tab, click 'Conditional Formatting', and select 'New Rule'.
3
Set the rule type
Select 'Format only cells that contain', then change the dropdown to 'Blanks'.
4
Choose your format
Click the 'Format' button to pick a fill color, then click 'OK' to apply.

=ISBLANK(A1)

You can also use the 'Go To Special' feature (F5 > Special > Blanks) to select all blank cells at once without applying a permanent rule.

Will this highlight cells that contain a space character?

No, Excel treats cells with a space as non-blank. You would need to use a formula rule like =LEN(TRIM(A1))=0 to catch those.