When you have a table with data, and you wish to retrieve specific information from it.
Conditional formatting enables you to highlight cells with a curtain color, depending on the cell’s value.
Using the Countif function in Excel
Launch Excel and type numbers as shown in the image below. Click on the Sum button on the ribbon and choose More Functions.