This will select all the blank cells in the dataset. In the Go To Special dialog box, select Blanks.In the Go To dialog box, click on the Special button.
Here are the steps to select and highlight blank cells in Excel: If you want to quickly select and highlight cells that are blank, you can use the ‘Go to Special’ technique. Select and Highlight Blank Cells in Excel Conditional Formatting is volatile, and if used on large data sets, may slow down your workbook. This means that if conditional formatting is applied and you delete a data point, that cell would get highlighted automatically.Īt the same time, this dynamic behavior comes with an overhead cost. Note that conditional formatting is dynamic. This would highlight all the blank cells in the dataset.
You can see there are blank cells in this dataset. Suppose you have a dataset as shown below: However, you can use these same techniques with large datasets as well. I am going to showcase these examples with a small dataset. Highlight Blank Cells Using Conditional FormattingĬonditional Formatting is a great way to highlight cells based on its value when the given condition is met. Using VBA to Highlight Blank Cells in Excel.Select and Highlight Blank Cells in Excel.Highlight Blank Cells Using Conditional Formatting.