Download the featured files here: https://www.bluepecantraining.com/wp-content/uploads/2021/10/Highlight-Blank-Cells.xlsx

In this video I demonstrate how to highlight blank cells by changing their background colour. This can be done in two ways:

1) Use Go To Special and select all blank cells and then format them
2) Use conditional formatting to format blank cells

Of the two methods, conditional formatting is the best as it automatically applies the format if a cell becomes blank and removes the format if the cell is no longer blank.
------------------------