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.

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.

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

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 .

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.

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 .

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

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.

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

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!