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.
- 4 basic steps for alternating coloring of lines in Microsoft Excel
- How to automatically highlight rows and columns in Excel
- 4 basic steps to color alternating columns in Microsoft Excel
- 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!
You should read it
- DCOUNTA function, how to use the function to count non-empty cells in Excel
- COUNTBLANK function - Count the number of blank (empty) cells in a selected range or array in Excel
- How to use the COUNT function in Excel
- The COUNTA function, how to use the function to count cells containing data in Excel
- Delete empty data cells in Excel 2007 or 2010
- Instructions on how to count words in cells in Excel
- COUNTIFS function in Excel
- The COUNTIFS function, how to use the cell count function according to multiple events in Excel
- COUNTBLANK function - The function performs counting empty cells in the list of arguments in Excel
- COUNT function - Function that counts cells containing numbers in the list of arguments in Excel
- How to Count Characters in Excel on PC or Mac
- Merge cells in Excel
May be interested
How to use Nitro Player to play videos and music on Windows
How to prepare images of Ephoto360
Please download Evertale, a monster-hunting game like Pokemon GO, which is free for both iOS and Android
How to use multi.link to create a personal website sharing page
What is the difference between AdBlock and Adblock Plus?
How to search for images similar to Bing