Return to Excel Formulas List

Highlight Blank Cells -Conditional Formatting

Download Example Workbook

Download the example workbook

This tutorial will demonstrate you how to highlight blank cells using Conditional Formatting in Excel and Google Sheets

Excel Highlight Blank Cells Main

 

Highlight Blank Cells with Conditional Formatting – ISBLANK Function

To highlight blank cells with conditional formatting, you can use the ISBLANK Function within a Conditional Formatting rule.

  1. Select the range to apply the formatting (ex. B3:E11)
  2. In the Ribbon, select Home > Conditional Formatting > New Rule.

Startup ISBLANK

  1. Select “Use a formula to determine which cells to format‘, and enter the following formula:

Edit Formatting Rule ISBLANK

  1. Click on the Format button and select your desired formatting.

Pick color ISBLANK.png

  1. Click OK, and then OK once again to return to the Conditional Formatting Rules Manager.Rules Manager ISBLANK
  2. Click Apply to apply the formatting to your selected range and then click Close.

Now your range is conditionally formatted if blank cells are detected:

ISBLANK-Final

Google Sheets –Highlight Blank Cells (Conditional Formatting)

All of the above examples work exactly the same in Google Sheets as in Excel.

Excel Highlight Blank Cells Google