I am working on a spreadsheet that counts my wins and losses regarding NFL
predictions. (i.e. marking the team name in red font which represents my
picks and yellow fill with the correct winner; the counting is needed to
tally up my wins and losses involving my predictions - teams with red font
and yellow fill = wins, teams with black font and yellow fill = losses)

I would like an answer that would allow me to use a function/formula
actually in Excel, not programming of some sort.

TIA