How to Highlight Blank Cells in Excel

This post will guide you how to highlight blank cells in Excel. How do I use Conditional Formatting to highlight blank cells in Excel.

Highlight Blank Cells with Go To Special Feature


If you want to highlight all blank cells in your select range of cells, you need to select all blank cells firstly, then you can fill color in those selected blank cells. Just do the following steps:

#1 select the range of cells that contain blank cells to be highlighted.

highlight blank cells1

#2 go to HOME tab, click Find & Select command under Editing group, and then select Go To Special from the popup menu list. And the Go To Special dialog will open.

highlight blank cells2

 

#3 select Blanks radio button  , and click OK button. You will see that all blank cells will be selected in the selected range of cells.

highlight blank cells3

highlight blank cells4

#4 go to HOME tab, click Fill Color icon under Font group, and choose one color as you need. All blank cells will be highlighted.

highlight blank cells5

highlight blank cells6

Highlight Blank Cells with Conditional Formatting


You can also use the conditional formatting to highlight blank cells in your selected range of cells in Excel, just do the following steps:

#1 select the range of cells where you want to highlight all blank cells

 highlight blank cells1

#2 go to HOME tab, click Conditional Formatting command under styles group. And select New Rules from the popup menu list. And the New Formatting Rule dialog will open.

highlight blank cells7

#3 select Use a formula to determine which cells to format in the Select a Rule Type list box, and type the following formula into the Format values where this formula is true: text box.

=B1=””

highlight blank cells8

Note: the Cell B1 is the first cell of your selected range of cells.

#4 click Format button to open Format Cells dialog, switch to Fill tab, and then choose one color as you like to fill. Click Ok button.

highlight blank cells9

#5 click OK button. All blank cells in selected range of cells have been highlighted.

highlight blank cells10

Video: Highlight Blank Cells

 

Leave a Reply