How to calculate and color blank cells in Excel

When working with Excel data tables, calculating data cells, the user must depend on the value base of each data cell in the table. And in an Excel table, not always full cells, there will be cells that contain empty or blank values. These random blank cells more or less influence the calculation of values. To quickly determine the total number of blank cells, cells without data, and to color cells without values, you can apply the Excel function and use conditions in Excel to color cells easily and easily. More convenient in calculation. The following article will guide you how to identify blank cells in Excel and color those blank cells.

1. 4 basic steps for alternating coloring of lines in Microsoft Excel
2. How to automatically highlight rows and columns in Excel
3. 4 basic steps to color alternating columns in Microsoft Excel
4. How to change the spreadsheet line color in Excel

Instructions for counting and coloring Excel empty cells

Step 1:

We have the following table of quantities with lots of random cells.

Picture 1 of How to calculate and color blank cells in Excel

In the input box, the number of blank cells has no value, users enter the formula = COUNTBLANK (B2: E11) and press Enter, where B2: E11 is the data range where users need to count the number of empty cells.

Picture 2 of How to calculate and color blank cells in Excel

As a result, we have the number of blank cells with no values ​​in Excel data tables.

Picture 3 of How to calculate and color blank cells in Excel

Step 2:

To clearly distinguish blank cells in an Excel table, users can color through conditional features in Excel. First, users highlight the whole Excel spreadsheet and then click on Conditional Formatting and select New Rule .

Picture 4 of How to calculate and color blank cells in Excel

Step 3:

Displays the New Formatting Rule interface so we can set the conditions for the worksheet. We click Use a formula to determine which Cells to format in the list below.

Picture 5 of How to calculate and color blank cells in Excel

Step 4:

Switch to the new interface we enter function = ISBLANK (B2) where B2 is the first cell in the worksheet to create conditions and then click the Format button .

Picture 6 of How to calculate and color blank cells in Excel

Display the Format Cells interface, then click the Fill tab and select a color to distinguish it from blank cells with no values.

Picture 7 of How to calculate and color blank cells in Excel

Step 5:

Finally, the user clicks OK to confirm the new condition of the data table, coloring the cells with empty values ​​in the table.

Picture 8 of How to calculate and color blank cells in Excel

The result of the table has the distinction between valuable cells and empty cells through the color we have chosen.

Picture 9 of How to calculate and color blank cells in Excel

Only with very simple operation, we have determined the number of blank cells with no values ​​in Excel data table. Those empty cells also need to be distinguished through color to make them easier to implement.

I wish you successful implementation!