You can't count based on formatting using a standard function - you
will need some VBA to give you that functionality, unless your colours
are based on conditional formatting (which they don't seem to be from
your description).

Pete

On Nov 25, 1:31*am, Clueless78217
wrote:
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