Highlight Blank Cells -Conditional Formatting

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

Excel Practice Worksheet

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

  • Automatically Graded Exercises
  • Learn Excel, Inside Excel!