In Excel, use =ISBLANK(A2) to check whether cell A2 is genuinely empty: the function returns TRUE for a blank cell and FALSE if the cell contains a value, text, a space, an error, or a formula—even one that displays nothing. Replace A2 with the cell you want to check, then use the TRUE or FALSE result in a larger formula, filter, or formatting rule.
What ISBLANK checks
ISBLANK is a logical function: it reports whether its argument refers to an empty cell. The result is the logical value TRUE or FALSE, not the words “TRUE” or “FALSE” stored as text. This makes it useful as a test inside functions such as IF, AND, and OR, or in a conditional-formatting rule.
“Empty” has a precise meaning here. A cell is blank when it has no contents. A cell containing a number, text, a date, a space character, or a formula is not blank to ISBLANK. Formatting alone—such as a fill color, border, or number format—does not put a value in a cell, so applying formatting to an otherwise empty cell does not make ISBLANK return FALSE.
The function takes one argument, usually a cell reference. It does not need a comparison operator or a second value. You can enter it directly in a worksheet cell, copy it down a column, or use it as part of another formula. Its simplicity is useful, but understanding what Excel counts as content is essential when a cell looks empty but the result is FALSE.
Basic use in a worksheet
Suppose a response sheet has customer names in column A, with the first record in row 2. To check whether A2 is empty, enter this formula in another cell on row 2. The layout assumes the name to test is in A2 and the result is placed somewhere else, such as B2:
=ISBLANK(A2)
If A2 has no contents, the result is TRUE. If a name has been entered, the result is FALSE. To check the next record, copy the formula down; the relative reference changes from A2 to A3, A4, and so on. You can also select the formula cell and fill it down using the fill handle at the lower-right corner of the selection.
Often, a worksheet is easier to read when the logical result becomes a message. With names in A2:A20 and the status formula in B2, this formula labels an empty name as missing and any nonempty cell as entered. Copy it down column B to check the rest of the list:
=IF(ISBLANK(A2),"Missing","Entered")
IF checks the TRUE/FALSE result from ISBLANK and returns the corresponding text. Choose labels that fit the task; for example, a form might use “Needs attention” and “Complete.” The formula only tests whether A2 contains anything. It does not establish whether the entry is valid: a typo, a dash, or an irrelevant note still counts as content.
Why a cell that looks empty may not be blank
The most common surprise is a formula that displays an empty string. A formula may return "" to hide a result until its inputs are available. The cell appears empty on the sheet, but it contains a formula, so ISBLANK returns FALSE. This distinction matters in reports that use formulas to suppress unused rows.
A cell can also contain one or more spaces. Spaces are text characters, even though they may be difficult to see, so ISBLANK returns FALSE. The same is true of an apostrophe used to enter text, a nonbreaking space copied from a webpage, or a formula that returns a space. If a cell contains an error value, it is not empty either; ISBLANK returns FALSE when directly checking that cell.
For a quick diagnostic, inspect the formula bar after selecting the cell. If it shows a formula, text, or a space, the cell is not truly empty. You can also test whether the cell appears empty to a formula by comparing it with an empty string. With the value to investigate in A2 and the test result in B2, use:
=A2=""
This comparison returns TRUE for a truly empty cell and for a formula result that is an empty string. It does not return TRUE for a cell containing ordinary spaces. The comparison answers a different question from ISBLANK; it is not a universal replacement. If imported data may include extra spaces, clean or inspect those entries rather than assuming either test detects every kind of invisible character.
Using ISBLANK with IF and other logic
Combining ISBLANK with IF lets you choose an output based on whether an input has been supplied. It can also be combined with AND or OR to check several required fields. For example, suppose an intake form requires both a name in A2 and an email address in B2. Put the check in C2; the formula labels the record incomplete only when both cells are truly empty:
=IF(AND(ISBLANK(A2),ISBLANK(B2)),"Incomplete","Review")
AND is appropriate in that example because the condition is “both are blank.” If the requirement is to flag a row whenever either required field is missing, OR is the relevant logical test instead. Decide what “incomplete” means before building the formula; using AND where OR is needed can let a partly filled record pass unnoticed.
ISBLANK tests cell occupancy, not the quality of the entry. If a cell contains a formula returning an empty string, the two-cell check above treats it as occupied. If the worksheet uses formulas to display blank-looking results, decide whether your business rule means “no formula or value exists” or “nothing visible to the user.” Use ISBLANK for the first meaning; an empty-string comparison may be more appropriate for the second.
Highlighting blank cells with conditional formatting
To highlight genuinely empty cells, select the cells to format and create a conditional-formatting rule. In Excel for Microsoft 365 on Windows, use Home > Conditional Formatting > New Rule > Use a formula to determine which cells to format. Choose a format, such as a fill color, and confirm the rule. On Mac, the Conditional Formatting controls are also on the Home tab, although the dialog layout can differ. In Excel for the web, the available rule-creation controls may differ from the desktop dialogs.
For example, suppose the range to highlight is A2:A20. Use this formula for the rule, with A2 as the top-left cell of the selected range:
=ISBLANK(A2)
Excel adjusts the relative row reference for each cell in the applied range, so A3 is tested on the next row. If the top-left cell of your selected range is different, update the reference to match it. Check the rule’s “Applies to” range if some cells do not format as expected. A formula returning an empty string will not be highlighted by this ISBLANK rule because its cell is not genuinely empty.
Conditional formatting changes how cells look; it does not put values in them or change what ISBLANK detects. This can be helpful for data-entry sheets, where a colored blank cell draws attention to a missing response. It can also make a workbook misleading if readers assume that colored cells are the only missing ones, so document whether the rule identifies truly empty cells or blank-looking formula results.
ISBLANK compared with COUNTBLANK and COUNTA
Choose the function that matches the question. ISBLANK checks one cell at a time and returns TRUE or FALSE. COUNTBLANK counts blank cells in a range; importantly, Excel also counts cells containing formulas that return an empty string as blank for COUNTBLANK. COUNTA counts cells containing data, including text, numbers, errors, and formulas that return empty text. Those differences explain why totals from these functions may not align with a visual scan.
For example, suppose B2:B20 contains responses and you want to count cells Excel considers blank for COUNTBLANK. Put the formula in a cell outside that range:
=COUNTBLANK(B2:B20)
With the same response range, use this to count cells that contain entries or formulas:
=COUNTA(B2:B20)
A formula returning "" can be included by COUNTA while also being counted by COUNTBLANK. Therefore, subtracting one count from the number of rows is not always a reliable way to calculate the other category when formulas are present. Spaces also count as content for COUNTA and are not considered blank by COUNTBLANK. For a precise audit, test a few representative cells and decide whether “blank” means physically empty or merely displaying nothing.
Common mistakes and troubleshooting
- Testing the wrong cell: Check that the reference points to the input cell, not the cell containing the ISBLANK formula. A formula cannot make its own cell blank while also displaying its result.
- Copying a conditional-formatting rule with the wrong reference: The reference should usually match the top-left cell in the applied range. An incorrect starting row can shift the test and highlight the wrong cells.
- Expecting spaces to count as blank: A space is content. Delete it or clean the source data if the goal is to remove invisible text; merely changing the cell’s format will not help.
- Confusing a displayed blank with an empty cell: Select the cell and inspect the formula bar. A formula that returns an empty string is still a formula and makes ISBLANK return FALSE.
- Using the test as data validation: ISBLANK can identify an empty input, but it does not prevent a user from entering an invalid value. Use appropriate data validation or a separate validity check when the requirement is to constrain entries.
If a copied formula does not behave as expected, inspect the references and the contents of the cells being checked. For large imported lists, also consider invisible characters and nonbreaking spaces, which may require cleaning rather than a simple blank test. Avoid deleting cells or clearing entire ranges until you have checked whether formulas or formatting elsewhere depend on them.
When ISBLANK is the right choice
Use ISBLANK when the question is specifically whether a cell has no contents—for example, identifying an unfilled form field, distinguishing unused rows from populated ones, or applying a rule to genuinely empty cells. Its result is predictable once you separate cell contents from cell appearance.
Choose another approach when the question differs. Use COUNTBLANK to count blank cells in a range, including formula results that are empty strings. Use COUNTA to count cells with content. Compare a cell with "" when you need to treat a truly empty cell and a formula result displaying empty text alike, while remembering that spaces still count as text. For data quality checks, use a rule that checks the allowed values rather than relying on blankness alone.
These functions are built into Excel for Microsoft 365 on Windows, Mac, and the web; there is no separate purchase or add-in needed. The key distinctions described here are about how Excel interprets cell contents, not a special paid feature. Menu layouts for formatting can vary by platform, but the basic ISBLANK formula works in the same way.
Frequently Asked Questions
Does ISBLANK return TRUE for a formula that displays nothing?
No. A cell containing a formula is not empty, even if the formula returns an empty string and the cell looks blank. ISBLANK returns FALSE for that cell.
How do I check whether a cell is blank in Excel?
Enter =ISBLANK(A1) in another cell, replacing A1 with the cell you want to check. TRUE means the referenced cell has no contents; FALSE means it contains something, including a formula or a space.
Does ISBLANK treat a cell with spaces as empty?
No. Spaces are text characters, so a cell containing spaces is not blank to ISBLANK. Delete the spaces or clean the data if those characters should not be there.
What is the difference between ISBLANK and COUNTBLANK?
ISBLANK tests a single cell and returns TRUE or FALSE. COUNTBLANK counts blank cells in a range and includes cells whose formulas return an empty string, so the two functions can treat a blank-looking formula cell differently.
Can I use ISBLANK in conditional formatting?
Yes. Create a formula-based conditional-formatting rule using ISBLANK and a reference to the top-left cell of the range. The rule highlights truly empty cells, but not cells containing formulas that display empty text.
Related
- Subscript in Excel: Shortcut Key and How to Apply It
- Excel Strikethrough Shortcut: Windows, Mac, and More
- Stop Excel Converting Text to Dates Before It Happens
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Open a CSV File in Excel With Separate ColumnsTo open a CSV file in Excel with its values in separate columns, use Data > From Text/CSV,…
- Excel Autofit Keyboard Shortcuts for Rows and ColumnsIn Excel for Microsoft 365 on Windows, select the column or row and press Alt, H, O, I…
- How to Insert a Line Through a Word in ExcelTo put a line through just one word in an Excel cell, edit the cell, select the word’s…
- How to See Protected Ranges in Google Sheets OnlineTo see protected ranges in Google Sheets, open the spreadsheet in a web browser and choose Data >…
- ISNUMBER in Excel: Check Whether a Cell Holds a NumberTo check whether a cell contains a number, enter =ISNUMBER(A2) in another cell, replacing A2 with the cell…
- Excel Max Value in a Column: Find the Largest NumberIf your values are in B2:B100, enter =MAX(B2:B100) in an empty cell; Excel returns the largest numeric value…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.