• Skip to main content
  • Skip to secondary menu
  • Skip to primary sidebar

Mechanicalengblog

siemens nx tutorial & injection molding technology

  • Plastic molding
  • Siemens nx
    • nx modeling
    • nx drafting
    • nx sketching
    • nx assembly
  • Mechanical basic
    • mechanical standard
    • Mechanism video
  • microsoft office
    • microsoft word
  • About me
  • CONTACT ME
Home » microsoft office » excel tips » How to count and color blank cells in excel

How to count and color blank cells in excel

March 4, 2021 by mechanicaleng blog Leave a Comment

If your task is to get Excel count and color blank cells in your worksheet, read this article to find the way to accomplish it. Learn how to count empty cells with Count Blank in Excel 2016,2013,2010,2019.

I. How to count blank cells in excel?

Step 1: Open the spreadsheet in Excel.
Step 2: Use COUNTBLANK function. Now you should note down the columns/rows for which you want to find the number of empty cells. It can be one or multiple columns, and it depends on your requirements.
Step 3: After that, click on an empty cell in your spreadsheet where you want to display the number. Then, enter a function like this: COUNTBLANK(F4:H12)
How to count blank cells in excel
This COUNTBLANK function counts empty cells between F4 and H12. You can change the column/row number as per your needs.

II. How to color empty cells in excel?

Step 1: Scan and select the worksheet area => then click Conditional Formatting => select New Rule.

color blank cells in excel 1

Step 2: The New Formatting Rule dialog box opens, where you click to select Use a formula to determine which Cells to format.
And in the next dialog box, enter the function below => and then click Format ..
= ISBLANK (you enter the first cell value in the worksheet selection)
Ex: I enter:= ISBLANK (F4)

color blank cells in excel 2

Step 3: Then open the Fill tab at the dialog box Format Cells => and select the colors you need to create => click OK to set.

color blank cells in excel 3

Then click OK to confirm in the New Formatting Rule dialog box, to apply the coloring of empty cell values on the selected Excel area.

I hope you know how to count and color blank cells in your Excel table. Feel free to share any other hints you may have. Be success!

——————————
User: NTHgg

Related posts:

change cell background color automatically in excelchange cell background color in excel by equal formulas Create border in excel by border tool2 ways to create border in excel Using CONCATENATE commandHow to add leading zeros in excel Random number from fixed set of optionsCreate random number in excel

Filed Under: excel tips Tagged With: excel beginner, excel tutorial

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar

Recent Posts

  • how to lock a word document from editing
  • How to insert page borders in ms word 2016
  • How to remove line breaks in word 2016
  • How to add bookmark and hyperlink in ms word
  • 2 ways to set long bond paper size in word
  • how to remove the background of a picture in word
  • How to insert checkbox in Word
  • How to insert and remove page break in word
  • How to draw shapes in Word?
  • Page number in word by roman numerals & numbers

Copyright © 2021 · Magazine Pro on Genesis Framework · WordPress · Log in