The evaluation and calculation of data cells in an Excel file is always based on that value. However, with long worksheets, the existence of countless random cells on a worksheet will affect your calculation more or less.
#first. Count the total number of empty cells in an Excel spreadsheet with a function COUNTBLANK
+ Step 1: First, open your Excel file. Here you click on the value export box.
+ Step 2: Then, you enter the function formula below => and then press
Enter to execute.
= COUNTBLANK(then scan the data area to be calculated)
Apply to the example we get CT: = COUNTBLANK (B2: E7)
+ Step 3: We get the total number of empty cells in the array (selection).
#2. How to color empty cell values on Excel spreadsheets
+ Step 1: In case you need to distinguish empty cells, by creating prominent colors for that empty cell, please do as follows.
First, scan the worksheet area => and then click
Conditional Formatting => select continue
+ Step 2: Dialog box
New Formatting Rule Open, here you click Use a fomula to determine which Cells to format.
+ Step 3: And in the next dialog, enter the function below => and then press
= ISBLANK(You enter the first cell value in the spreadsheet selection)
Applied to the example we have the formula: = ISBLANK (B2)
+ Step 4: Then open the tab
Fill at the dialog box
Format Cells => and choose the color you need to create => click
OK to establish.
+ Step 5: Then press
OK to confirm at the dialog box
New Formatting Rule, to apply the fill color to empty cell values on selected Excel area.
And this is the result after we're done.
# 3. Epilogue
Okay that's it, I have to guide you How to count blank cells in a data range in Excel and color according to that value, using the formula COUNTBLANK and ISBLANK in a very simple way.
At this point, the tutorial on counting and coloring empty cells in my Excel spreadsheet is also asking to pause. Hope this tip will be helpful to you.
Good luck !
CTV: Luong Trung - Blogchiasekienthuc.com
Note: Was this article helpful to you? Do not forget to rate the article, like and share it with your friends and relatives!Read more :
- How to remove folders in WordPress helps secure the website
- Litecoin Foundation became the producer of a horror film
- Mã Postcode - SWIFT CODE - Zip code của các ngân hàng Việt Nam
- Twitter added the Bitcoin emoticon, Jack Dorsey suggested that Unicode should do the same
- Candlestick trading tactics at IQ Option | Money Blog