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
- Highlight Blank Cells with Conditional Formatting
- Video: Highlight Blank Cells
Table of Contents
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.
#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.
#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.
#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.
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
#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.
#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.
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.
#5 click OK button. All blank cells in selected range of cells have been highlighted.