Select the cell in which you'd like to display your COUNTIFS output. Within a set of parentheses, you should first include a cell range of where you want the function to look, a comma, and then what ...

How to Use If-Then Excel Equations to Color Cells. ... Apply this rule to cells, and you can make Excel highlight words that contain text you specify without writing code to perform that task.