To count highlighted cells in Excel, use the conditional formatting option to highlight the desired cells and then create a formula that counts the number of cells with the specified formatting; the output will be the number of highlighted cells. Number of highlighted cells.