Highlight Blank Cells -Conditional Formatting

Written by

Editorial Team

Reviewed by

Steve Rynearson

Last updated on February 4, 2023
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.


  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:


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

AI Formula Generator

Try for Free

Excel Practice Worksheet

practice excel worksheet

Practice Excel functions and formulas with our 100% free practice worksheets!

  • Automatically Graded Exercises
  • Learn Excel, Inside Excel!

Free Download

Return to Excel Formulas List