To count and search for text in Excel, use the COUNTIF function. This function allows you to search for a specific value or pattern in a range of cells and count the number of cells that match the criteria. To highlight the cells that match the search criteria, use the "Conditional Formatting" option in the "Home" tab of the ribbon and choose the formatting options for the highlighted cells. To count the number of highlighted cells, use the COUNTIF formula again with the same search criteria. br br This is how you can do it. br br Search And Highlight Cell(s) br 1) Select cells. br 2) Home -- Styles -- Conditional Formatting br 3) New Rule... br 4) Select " Use a formula to determine which cells to format" br 5) Enter this formula br =COUNTIF($C$2:$C$6,A2) br 6) Format... br 7) Fill tab br 8) Select color br 9) OK br 10) OK br br Count How Often A Value Occurs br 1) Select cell. br 2) Enter this formula br =COUNTIF(A:A,C2) br 3) Apply to rest of the rows.