Excel 2007 : count highlighted cells

**billthehulk** · 10-07-2009, 09:47 PM

I have a spread sheet for a weekly office nfl football pool
I Have the teams that are playing in the far left column then in the columns there after are the teams players pick to win I want to hilite the winning team in yellow then I want all the teams that people picked that won hilited in yellow automatically then at the bottom of the screen I want the sum of all hilited cells counted to show how many winning picks they got

**DonkeyOte** · 10-08-2009, 09:56 AM

You don't really outline where you want your final output to reside ?

I want to hilite the winning team in yellow then I want all the teams that people picked that won hilited in yellow automatically

Can you not just base this off the score which I am presuming is what is appearing in the row below... eg if you select range D3:Q34 you can apply a Conditional Format rule of:

=AND(ISNUMBER($A4),INDEX($A3:$C3,1+2*($C4>$A4))=D3)
set fill to yellow

This should highlight all correct predictions.

As I say I'm not quite sure I follow in terms of where you wish to output the total correct picks.

Your life would be a lot (lot) easier if you stored the winning team in a common cell on each row (eg inserted column D and used formula to return the winning team name for each fixture).