This article explains how to use the ISBLANK function in Microsoft Excel 365, Excel 2016, and 2019 (though the menu layouts may vary slightly).

There are a number of different ways you can use ISBLANK for various purposes, but a simple example is to determine whether a range of cells is empty or filled. This can be very useful if you want a database to be complete, but searching it manually would take a while.

In this example, we use a sample dataset that contains a range of Data that could actually represent anything. In column B, we use the following formula:

Copying and pasting that formula into the entire Needs Data Column will replace the cell with the next consecutive cell in the corresponding Data range. This will return a result of False in all rows that do contain data, and True in cells that do not, suggesting that data needs to be entered.