You are currently viewing How to count cells that are highlighted in Excel

How to count cells that are highlighted in Excel

When we need to make changes, adjust, delete, update, and even erase a particular cell in excel sheets, we do what we refer to as highlight. A highlighted cell will appear in a different colour than that of the other cells. This is to make it easily visible for the viewer or the one who is intending to make changes.

To highlight is the act or the general process of selecting or marking the entire cell in an excel sheet. As said earlier, we mark to make changes to the cell or cells. Once we do marking to any given cell, we may need to count how many cells have been selected.

Counting the highlighted cells in a given excel sheet is just the act or process of getting the correct tally of the quantity in numeral values that is the numbers. For us to achieve the correct count there are some steps we should adhere to from top to bottom. These steps are discussed in detail with examples below.

1. On your personal computer or laptop, open a blank excel sheet from Microsoft Excel. Insert some data into the excel sheets. Before we can count we need to have first the selected or the highlighted cells in our data. To do the selection, select the cells you need to highlight and give them a different color from the original color. Color by going to the home button and select the fill color

2. We are now going to count or get the correct tally of all the selected cells on that excel sheet. To do this, a function SUBTOTAL is going to help us achieve the correct result. In this case, we need to get the count of all the cells highlighted in the excel sheet, so we are going to count from cell A3 to cell C8 and our result will appear at the bottom on cell D9.

The formula will be = SUBTOTAL (3, A3: C3) which we will key in on the formula bar.

In the scenario, the number of highlighted cells between cell A3 and C3 is three.