Table of Contents

If Cell is Blank

Use the IF function and an empty string in Excel to check if a cell is blank. Use IF and ISBLANK to produce the exact same result.

If Blank

Remember the IF function in Excel checks whether a condition is met and returns one value if true and another value if false.

1. The IF function below returns Yes if the input value is equal to an empty string (two double quotes with nothing in between) else it returns No.

Check If a Cell is Blank

Note: if the input cell contains a space it looks blank. However if this is the case the input value is not equal to an empty string and the IF function above will return No.

2. Use IF and ISBLANK to produce the exact same result.

IsBlank Function in Excel

Note: the ISBLANK function returns TRUE if a cell is empty and FALSE if not. If the input cell contains a space or a formula that returns an empty string it looks blank. However if this is the case the input cell is not empty and the formula above will return No.

If Not Blank

In Excel <> means not equal to.

1. The IF function below multiplies the input value by 2 if the input value is not equal to an empty string (two double quotes with nothing in between) else it returns an empty string.

Check If a Cell is Not Blank

2. Use IF NOT and ISBLANK to produce the exact same result.

Not and IsBlank Function in Excel

Highlight Blank Cells

You can use conditional formatting in Excel to highlight cells that are blank.

1. For example select the range A1:H8.

Select Cells

2. On the Home tab in the Styles group click Conditional Formatting.

Click Conditional Formatting

3. Click Highlight Cells Rules More Rules.

More Rules

4. Select Blanks from the drop-down list select a formatting style and click OK.

Select Blanks

Result:

Highlight Blank Cells

Note: visit our page about conditional formatting to learn much more about this cool Excel feature.

Leave A Comment

Excel meets AI – Boost your productivity like never before!

At Formulas HQ, we’ve harnessed the brilliance of AI to turbocharge your Spreadsheet mastery. Say goodbye to the days of grappling with complex formulas, VBA code, and scripts. We’re here to make your work smarter, not harder.

Related Articles

The Latest on Formulas HQ Blog