You can use the IF statement alongside Excel's conditional formatting to change the cell's color based on conditions. You can ...

To use COUNTIF: Select the cell in which you'd like to display your COUNTIF output. Type in the =COUNTIF function. Within a ...