Count highlighted and text specific cells

KarenBBM5515 

I "borrowed" a user defined function from https://www.exceltip.com/tips/how-to-get-color-of-the-cell-using-vba-in-microsoft-excel-2010.html 

It allows you to read out the background colour of a cell. On my Mac, yellow has the value of 6. I you can live with adding a (perhaps hidden) column that checks if the cell colour value is 6, then you can use a formula like:

=SUMPRODUCT(B1:B7*(A1:A7="PT"))

..... to count the number PT with a yellow background, as demonstrated in the attached file.