How to maintain data integrity by identifying blank cells in a worksheet

To maintain data integrity in your worksheet you can start by identifying cells that are blank, possibly due to data capturing error or because they have been left as place holders for vital information and forgotten. This gives you the opportunity to complete capturing and have a complete data set which is vital for data analysis.

Today, we’ll show you how to use Conditional Formatting to highlight blank cells in a worksheet. Follow these simple steps to help you ensure that your data is legit.

Note: Download the sample workbook to practice this exercise.

Applies To: Microsoft® Excel® 2007, 2010 and 2013

  1. Highlight the data range .In our example it is A2:F27.
  2. Select Conditional Formatting.




3. Then select New Rule as below.








4. Select a rule type and description as below.










  1. To format the cells click on the Format button.










  1.  Select the color of choice and click OK.












  1. Click OK to complete the process.











As can clearly be seen all the blank cells are highlighted in blue. Thus the missing cells can quickly be filled in with information and the data integrity of the worksheet maintained.